topic Stored Procedure Output Parameters Oracle ODBC in QlikView https://community.qlik.com/t5/QlikView/Stored-Procedure-Output-Parameters-Oracle-ODBC/m-p/151378#M29245 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I am trying to call a stored procedure in Oracle via ODBC which has 2 output parameters:</P><P>MyProc (IN p1, IN p2, IN p3, OUT o1, OUT o2)</P><P>o1 is a NUMBER, o2 is a VARCHAR2<BR />p1,p2,p3 are all NUMBER</P><P>I already call stored procedures with only IN parameters (SQL CALL MySimpleProc (a,b,c);)<BR />This is working fine.<BR />But I can't get it work with output parameters <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>Q: How to do it ?</P><P>Thanks in advance,<BR />Thilo</P><P></P></BODY></HTML> Wed, 09 Mar 2011 15:38:07 GMT 2011-03-09T15:38:07Z Stored Procedure Output Parameters Oracle ODBC https://community.qlik.com/t5/QlikView/Stored-Procedure-Output-Parameters-Oracle-ODBC/m-p/151378#M29245 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I am trying to call a stored procedure in Oracle via ODBC which has 2 output parameters:</P><P>MyProc (IN p1, IN p2, IN p3, OUT o1, OUT o2)</P><P>o1 is a NUMBER, o2 is a VARCHAR2<BR />p1,p2,p3 are all NUMBER</P><P>I already call stored procedures with only IN parameters (SQL CALL MySimpleProc (a,b,c);)<BR />This is working fine.<BR />But I can't get it work with output parameters <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>Q: How to do it ?</P><P>Thanks in advance,<BR />Thilo</P><P></P></BODY></HTML> Wed, 09 Mar 2011 15:38:07 GMT https://community.qlik.com/t5/QlikView/Stored-Procedure-Output-Parameters-Oracle-ODBC/m-p/151378#M29245 2011-03-09T15:38:07Z