17,089
社区成员
发帖
与我相关
我的任务
分享
create or replace function sql_test (sql_str varchar2) return SYS_REFCURSOR is
po_return sys_refcursor;
begin
open po_return for sql_str;
return(po_return);
end ;
--调用函数
declare
cur1 SYS_REFCURSOR;
v_dual varchar2(100);
i number;
begin
v_dual:='select 1 id from dual union all select 2 from dual';
cur1:=sql_test(v_dual);
loop
fetch cur1 into i;
exit when cur1%notfound;
dbms_output.put_line('----------------i :'||i);
end loop;
close cur1;
end;