Hi All.
I am new in using DBMS_SQL package.
DBMS_SQL uses OPEN_CURSOR function which returns a number. How may I use this number (which is a cursor in DBMS_SQL meaning) as a return of a function defined to return SYS_REFCURSOR?
create or replace function my_test_func return sys_refcursor is
refcur sys_refcursor;
v_stmt varchar2(5000);
c number;
dummy number;
begin
v_stmt := 'SELECT * FROM ALL_OBJECTS';
c := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(c, v_stmt, DBMS_SQL.NATIVE);
dummy := DBMS_SQL.EXECUTE(c);
-- (...) how to convert 'c' to 'refcur'?
return refcur;
end;
I am using Oracle 19c.
Thanks in advance,
Jacek