Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex78
Contributor III
Contributor III

Execute Oracle Procedure with Ref Cursor in Qlik Sense

Hi. 

I have an oracle package/procedure with parameters and ref Cursor. You would normally call it in Oracle SQL Developer as

p_rc sys_refcursor;
begin

myPackage.myProcedure(v_parm1, v_parm2, v_parm3, p_rc )

return p_rc;

end;

How can I call this procedure with ref cursor in Qlik Sense to load the result data (which have multiple columns and rows)?

Thank you

 

Labels (3)
1 Reply
Alex78
Contributor III
Contributor III
Author

Any one to look at this?