oracle多张表分页,oracle的多表分页存储过程调用疏失

oracle的多表分页存储过程调用出错

点击右边红色标题查看本文完整版：oracle的多表分页存储过程调用出错

oracle的多表分页存储过程调用出错,今天写了个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

我的异常网推荐解决方案：oracle存储过程,http://www.myexceptions.net/oracle-develop/177537.html