
Creator
2019-11-03
11:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
2,369 Views
1 Reply

Contributor
2020-12-04
08:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
2,023 Views
