建立oracle存储过程查询数据集合步骤

1、建立包

create or replace package busi is

  type v_cursor is ref cursor;

end busi;

2、实现包体
create or replace package body busi is

end busi;

3、建立存储过程

create or replace procedure Test
(
mycur out busi.v_cursor
)
is
begin
open mycur for select * from dual;

end Test;