今天写了个oracle的多表分页存储过程，但是在调用时会出错，请各位帮忙看下

Question

今天写了个oracle的多表分页存储过程，但是在调用时会出错，请各位帮忙看下
--创建包规范
create or replace package package_page as
  --author:liubg
  --createTime:2008-08-18 10:30
  --purpose:分页返回数据集
  type cursor_page is ref cursor;
  Procedure proc_page( 
            p_curpage Number,                     --当前页
              p_pagesize Number,                    --页面大小
            --p_sql  varchar2,                 
              p_cursor out cursor_page);            --结果集
end package_page;--创建包主休
Create Or Replace Package Body package_page
Is
      Procedure proc_page(
             p_curpage Number,
             p_pagesize Number,
             --p_sql  varchar2, 
             p_cursor out cursor_page
      )
      is
            v_count_sql varchar2(2000);
            v_select_sql varchar2(2000);
      begin
               v_select_sql:='select * from(select kc.key_class_name,
                            substr(km.sm_content, 0, 19) || "...." ct,
                            substr(zu.usernickname, 0,5) shortname,
                              km.total_count,
                              to_char(km.pass_time, "YY-MM-DD") pt,
                              zu.usernickname,
                              km.key_message_id,
                              row_number() over ( order by km.pass_time desc ) rn
                          from key_class kc,zk_product z
                          left join key_message_new km on z.prosourceid = km.key_message_id
                          left join zk_product_type zt on zt.protypeid = z.protypeid
                          left join zk_users zu on zu.userid = z.userid
                         where km.audit_tag > 2
                           and km.user_visible = 1
                           and km.key_status = 1
                           and kc.id=km.key_class )where rn between'||((p_curpage-1)*p_pagesize)||'   and '||(p_curpage*p_pagesize);
              
open p_cursor for v_select_sql;
end proc_page;
end package_page; 
----------------测试----------------
declare
       v_cursor package_page.cursor_page;
begin  
       package_page.proc_page(1,8,v_cursor);
end;