Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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.