CREATE OR REPLACE package p_test as
type t_myrc is ref cursor;
function f_getdata return t_myrc;
end p_test;
/
CREATE OR REPLACE package body p_test as
function f_getdata return t_myrc is
rc t_myrc;
begin
open rc for 'select * from users' ;
return rc;
end;
end p_test;
/
