Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.