--这个是存储过程,以scott登录 create or replace p_test(p_1 out sys_refcursor, p_2 out sys_refcursor) is begin open p_1 for select * from emp; open p_2 for select * from emp; end;--在sqlplus下执行的 sql> var x1 refcursor; sql> var x2 refcursor; sql> begin p_test(:x1, :x2); end; sql> print :x1; sql> print :x2;
create or replace p_test(p_1 out sys_refcursor, p_2 out sys_refcursor)
is
begin
open p_1 for select * from emp;
open p_2 for select * from emp;
end;--在sqlplus下执行的
sql> var x1 refcursor;
sql> var x2 refcursor;
sql> begin p_test(:x1, :x2); end;
sql> print :x1;
sql> print :x2;