【 使用版本 】3.2.3.0
【问题描述】分页语句报错，错误：ErrorCode = 600, SQLState = HY000, Details = ORA-00600: internal error code, arguments: -4016, Internal error
【sql语句】
select * from
(
select tmp_page.*, rownum as row_id from
( select t.f_userid as userId ,t.vc_userNo as userNo ,t.vc_account as account ,t.vc_password as password ,
t.vc_username as userName ,t.vc_nickname as nickName ,t.vc_sex as sex ,t.f_age as age ,t.vc_cellPhone as cellPhone ,
t.vc_telePhone as telePhone ,t.vc_email as email ,t.vc_fax as fax ,t.vc_condition as condition ,t.vc_status as status
,decode(t.vc_status, ‘0’, ‘启用’, ‘1’,‘禁用’, ‘’) as statusName ,t.f_companyid as companyId ,
to_char(t.D_CREATEDATE,‘yyyy-mm-dd hh24:mi:ss’) as createDate ,to_char(t.d_updateTime,‘yyyy-mm-dd’) as updateTime
,t.vc_remark as remark ,
(select wm_concat(d.VC_DEPTNAME) from SYS_DEPT d start with d.F_DEPTID =
(select F_DEPTID from SYS_USER_DEPT where SYS_USER_DEPT.F_USERID = t.F_USERID and rownum=1 )
connect by prior d.F_DEPTPID = d.F_DEPTID ) as deptNames
, (SELECT e.dim_nme FROM e_dim_portal e WHERE e.dim_type = ‘lock_account’
AND e.dim_cde = decode ((SELECT s.f_status FROM sys_login_log_manager s
WHERE s.f_userid = t.f_userid AND s.f_status = ‘0’),‘0’,‘0’,‘1’)) AS accountStatusName,
decode ((SELECT s.f_status FROM sys_login_log_manager s WHERE s.f_userid = t.f_userid AND s.f_status = ‘0’),‘0’,‘0’,‘1’) as accountStatus,
(select wm_concat(r.vc_rolename) from sys_user_role ur,sys_role r where ur.f_roleid=r.f_roleid and ur.f_userid=t.f_userid ) as roleNames ,
(select sd.vc_deptname from sys_dept sd where sd.F_DEPTID=t.f_companyid) as companyName
from sys_user t where 1=1 and t.f_userid=1 )
tmp_page
) where row_id <= 10 and row_id > 0
4016的报错原因有很多，很多跟sql有关系，建议你分段去执行下sql判断是哪段出问题， 然后对照下官网的报错文档看对应的处理方式
谢谢哈，不用了。
我这边已经按照语法文档，新增了分页代码，支持ob oracle的个性化分页了。
分页语法：OFFSET xxx ROWS FETCH FIRST yyy ROWS ONLY
xxx：起始分页数据行数
yyy：每页数据条数
1 个赞