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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?