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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stored Procedure Output Parameters Oracle ODBC

Hello all,

I am trying to call a stored procedure in Oracle via ODBC which has 2 output parameters:

MyProc (IN p1, IN p2, IN p3, OUT o1, OUT o2)

o1 is a NUMBER, o2 is a VARCHAR2
p1,p2,p3 are all NUMBER

I already call stored procedures with only IN parameters (SQL CALL MySimpleProc (a,b,c);)
This is working fine.
But I can't get it work with output parameters 😞

Q: How to do it ?

Thanks in advance,
Thilo

0 Replies