--创建procedure
create
or
replace
procedure
sql_test(out_return
out
sys_refcursor)
is
begin
open
out_return
for
'select * from tgp_funds'
;
end
;
--引用
declare
cur1 SYS_REFCURSOR;
i tgp_funds%rowtype;
begin
sql_test(cur1);
loop
fetch
cur1
into
i;
exit
when
cur1%notfound;
dbms_output.put_line(
'----------------:'
|| i.fnd_id);--fnd_id为表tgp_funds中的fnd_id 列
end
loop;
close
cur1;
end
;