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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-03-09 10:38 AM

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

1,121 Views
0 Likes
0 Replies