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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dx_anupam
Creator
Creator

How to fetch data from Oracle PLSQL Sys_Refcursor in qliksense

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

 

Labels (2)
1 Reply
esraltnl
Contributor
Contributor

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.