How to fetch data from Oracle PLSQL Sys_Refcursor in qliksense

dx_anupam — Tue, 28 Dec 2021 20:17:54 GMT

Hello friends,

I am having a oracle package with the stored procedure as below

declare

ref_cursor sys_refcursor;

l_col1 number;

l_col2 number;

l_col3 Date;

begin

packagename.Procedurename (ref_cursor);

loop

fetch ref_cursor

into l_col1, l_col2,l_col3;

exit when refcursor%notfound;

dbms_output.put_line( l_col1);

dbms_output.put_line( l_col2);

dbms_output.put_line( l_col3);

end loop;

close ref_cursor;

end;

How to write this code in qliksense

Re: How to fetch data from Oracle PLSQL Sys_Refcursor in qliksense

esraltnl — Fri, 04 Dec 2020 13:26:40 GMT

hi, did you solve this problem? Can data be retrieved from the oracle database via procedure ref-cursor in Qliksense?

Thank you very much for your answer.