CREATE OR REPLACE PACKAGE pkg_test AS TYPE myrctype IS REF CURSOR; END pkg_test; / create procedure pro(p_id in varchar2,p_rc out pkg_test.myrctype) as v_sql varchar2(50); begin v_sql:='select * from table_name where id='||p_id; open p_rc for v_sql; end; /
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
create procedure pro(p_id in varchar2,p_rc out pkg_test.myrctype)
as
v_sql varchar2(50);
begin
v_sql:='select * from table_name where id='||p_id;
open p_rc for v_sql;
end;
/