create or replace procedure p_test(p_cur out sys_refcursor)
as
begin
open p_cur for select * from emp;
end p_test;
SQL> var r refcursor;
SQL> exec p_test(:r);
SQL> print r;
as
begin
end p_test;
SQL> var r refcursor;
SQL> exec p_test(:r);
SQL> print r;