oracle存储过程返回集合

1.首先创建一个包

create or replace package cy_types
as
type empinfotype is ref cursor
return cyg%ROWTYPE;
end cy_types;

2.创建储存过程

create or replace procedure pro_test
(
 emp_cv in out cy_types.empinfotype
)
as
begin open emp_cv for select * from cyg;
end;

 

3.进行测试

variable odcv refcursor;

execute pro_test(:odcv);

print odcv;