Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.