Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Contributor

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