SQL> create or replace package pkg_return_list as -- 创建包pkg_return_list及包的游标list_cursor, 该游标等下做pro_return_list的返回参数类型.
2 type list_cursor is ref cursor;
3 end pkg_return_list;
4 /
SQL> create or replace procedure pro_return_list(p_cursor out pkg_return_list.list_cursor) is -- 创建存储过程pro_return_list, 并把p_cursor的类型定义为pkg_return_list.list_cursor.
2 begin
3 open p_cursor for select * from scott.tb_do_only;
4 end pro_return_list;
5 /
2 type list_cursor is ref cursor;
3 end pkg_return_list;
4 /
SQL> create or replace procedure pro_return_list(p_cursor out pkg_return_list.list_cursor) is -- 创建存储过程pro_return_list, 并把p_cursor的类型定义为pkg_return_list.list_cursor.
2 begin
3 open p_cursor for select * from scott.tb_do_only;
4 end pro_return_list;
5 /