ORA-00600: 内部错误代码, 参数: [kkoipt:invalid join method]
分页查询要注意SQL:
SELECT t2.ID FROM( SELECT t1.ID, ROWNUM rnum FROM( SELECT t0.ID From( SELECT p.ID,MAX(pa.GMT_CREATE) as gmt_create FROM mkt_product p, mkt_product_activity pa, mkt_activity a WHERE p.ID = pa.MARKETING_PRODUCT_ID AND pa.MARKETING_ACTIVITY_ID = a.ID AND a.is_valid = 1 AND p.scm_industry is null GROUP BY p.id )t0 order by t0.gmt_create desc nulls last ) t1 WHERE ROWNUM <= 5) t2 WHERE rnum >= 0 其中ROWNUM<5改为ROWNUM<20则可运行，若为5则报错
数据库报错：
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state ; error code ; --- The error occurred while applying a parameter map.--- Check the marketingProductActivity.getApplyProductIDListByQuery-InlineParameterMap.--- Check the statement (query failed).--- Cause: java.sql.SQLException: ORA-00600: 内部错误代码, 参数: , , , [], [], [], [], [], [], [], [], []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map.--- Check the marketingProductActivity.getApplyProductIDListByQuery-InlineParameterMap.--- Check the statement (query failed).--- Cause: java.sql.SQLException: ORA-00600: 内部错误代码, 参数: , , , [], [], [], [], [], [], [], [], []
解决：
是由于分页SQL中第二层没有加上ROWNUM，加上即可：
SELECT t2.ID FROM( SELECT t1.ID, ROWNUM rnum FROM( SELECT t0.ID, ROWNUM From( SELECTp.ID,MAX(pa.GMT_CREATE) as gmt_create FROM mkt_product p, mkt_product_activity pa, mkt_activity a WHERE p.ID = pa.MARKETING_PRODUCT_ID AND pa.MARKETING_ACTIVITY_ID = a.ID AND a.is_valid = 1 AND p.scm_industry is null GROUP BY p.id )t0 order by t0.gmt_create desc nulls last ) t1 WHERE ROWNUM <= 5) t2 WHERE rnum >= 0
页:
[1]