oracle游标（返回多条数据）分页

create or replace package test_mypackage1 as
--声明类型，并引用游标
type cursorType is  ref cursor;
  --声明存储过程，两个输入参数，一个输出参数，输出游标类型数据
  procedure prcGetGlobalAddress(pos1 integer,
                                --分页查询的下限
                                pos2 integer,
                                --分页查询的上限
                                cur in out test_mypackage1.cursorType
                                --输出参数，数据类型为引用游标的类型
                                );
end test_mypackage1;

create or replace package body test_mypackage1 as
--定义存储过程
       procedure prcGetGlobalAddress(pos1 integer, pos2 integer, cur in out test_mypackage1.cursorType) as
       begin
--返回得到分页查询结果集的游标句柄
       open cur for select * from(select a.*, rownum rn from(select * from me