创建存储过程procedure – p_test
create or replace procedure p_test(p_cur out sys_refcursor) is
begin
open p_cur for select * from tb_user;
end p_test;
调用p_test存储过程,并且得到select查询的结果集
declare
p_cur sys_refcursor;
i tb_user%rowtype;
begin
p_test(p_cur);
loop
fetch p_cur into i;
exit when p_cur%notfound;
dbms_output.put_line('用户名:'||i.U_USERNAME);
end loop;
close p_cur;
end;
得到select查询的结果集
用户名:admin
用户名:kaoshiyuan