Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tOracleSp - calling an Oracle Package

Hi,
I need to run the following package from Talend:
BEGIN
IO_ERRMSG := NULL;
IO_ERRNO := NULL;
I_CATEGORY_ID := 129;
I_CHARGE_ACC_SEG5 := '6500';
I_DEBUG_FLAG := 'Y';
APPS.VRTX_VICI_ORDER_INTF_PKG.MAIN_PROCESS ( IO_ERRMSG, IO_ERRNO, I_CATEGORY_ID, I_CHARGE_ACC_SEG5, I_DEBUG_FLAG );
COMMIT;
END;
What is the best way to do this?
I tried the following, but am getting a lot of different errors, and it does not look like I am using a correct approach:
tOracleInput --> tMap --> tOracleSP
tOracleInput has select 1 from dual
in tMap I define the 5paramaters that are needed, and pass to tOracleSP.
The latest errors I am getting is "Parameter schema is different from query" on tOracleInput, and PLS-00221: 'VRTX_VICI_ORDER_INTF_PKG' is not a procedure or is undefined
ORA-06550: line 1, column 7:
What should I have in tOracleSP, in SP Name, just the oracle package name????
Anyway, please let me know how to get this to work.
Thanks,
Boris
Labels (2)
10 Replies
Anonymous
Not applicable
Author

Hello @dmutu,

It's a quite old thread. Could you please give us a more bit information about your job design and problem? Screenshots will be preferred.

Best regards

Sabrina