function返回sys_refcursor

function:

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;