ORA-00600: 内部错误代码, 参数: [qctcte1], [0], [], [], [], [], [], []

Question

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
at $Proxy27.execute(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
... 89 more[2012-03-13 14:17:52]-[DEBUG] com.opensymphony.xwork2.util.logging.commons.CommonsLogger.debug(CommonsLogger.java:57) 
 Forwarding to location /WEB-INF/page/manage/common/exception.jsp
[2012-03-13 14:17:52]-[DEBUG] com.opensymphony.xwork2.util.logging.commons.CommonsLogger.debug(CommonsLogger.java:57) 
 Entering nullPropertyValue [target=[com.itenp.gen.action.ExceptionAction@1566060, com.opensymphony.xwork2.interceptor.ExceptionHolder@1d1695e, com.itenp.bymis.action.JFZDAction@1f4c4a3, com.opensymphony.xwork2.DefaultTextProvider@16c2c0], property=org]
[2012-03-13 14:17:52]-[DEBUG] com.opensymphony.xwork2.util.logging.commons.CommonsLogger.debug(CommonsLogger.java:57) 
 after Locale=zh_CN
[2012-03-13 14:17:52]-[DEBUG] com.opensymphony.xwork2.util.logging.commons.CommonsLogger.debug(CommonsLogger.java:57) 
 intercept } 
[2012-03-13 14:17:52]-[DEBUG] com.opensymphony.xwork2.util.logging.commons.CommonsLogger.debug(CommonsLogger.java:57) 
 Entering nullPropertyValue [target=[com.itenp.gen.action.ExceptionAction@1566060, com.opensymphony.xwork2.interceptor.ExceptionHolder@1d1695e, com.itenp.bymis.action.JFZDAction@1f4c4a3, com.opensymphony.xwork2.DefaultTextProvider@16c2c0], property=__cleanup_recursion_counter]

Answer 1

内部错误代码，伤不起。JDBC的jar包与数据库不匹配？

Answer 2

但是 条件改成死的就不报错啊
 select rownum ,row_number() over(partition by w.areaid order by w.areaid , w.winid )t_row,(CASE when GROUPING(rownum)= '1'
   and GROUPING(w.areaid)='1' then '总计' WHEN GROUPING(rownum)='1' THEN '小计'     
    else w.areaid||'_'||w.winid       
        END )dsdid ,sum( case w.fkqk when '0' then nvl(q.yxps,0)  else '0'  end )as qyxps,   
      sum(w.yxps) wyxps,sum( nvl(q.yxps,0) + nvl(w.yxps,0)) sumyxps,  
        sum(case w.fkqk when '0' then nvl(q.yjje,0.0)  else 0 end) qyjje,sum(nvl(w.yjje,0)) wyjje,
         sum(case q.yjje when 0 then w.yjje else  nvl(q.yjje,0)+nvl(w.yjje,0) end) sumyjje ,sum(case w.fkqk when '0'
          then 0 else  nvl(q.yjje,0)+nvl(w.yjje,0) end) as paid,     
           sum(case  w.fkqk when '0'  then nvl(q.yjje,0)+nvl(w.yjje,0) else 0  end)as poor       
      from   
      (select t_row,dsdid,ny,rq,zq,area,areaid,winid,qps,xsps,yxps,     
           nvl(yjje,0.0) yjje,fkqk,bz,nvl(sp1,0) sp1,sp2,sp3,sp4,      
           sp5,sp6,sp7,sp8,sp9,sp10 from (    
             select rownum t_row,b.dsdid,a.* from xt_dsd b    
            ,(   
             select ny,rq,zq,area,areaid,winid,qps,xsps,yxps,   
              nvl(yjje,0.0) yjje,fkqk,bz,nvl(sp1,0) sp1,sp2,sp3,sp4,      
              sp5,sp6,sp7,sp8,sp9,sp10 from jfzd a        
               )a where b.area=a.area(+) and b.winid=a.winid
   
     条件       and a.area='GMK'  and a.ny='201201' and a.winid='7'
         
     )order by dsdid,winid) w   
             , 
    (select t_row,dsdid,ny,rq,zq,area,areaid,winid,qps,xsps,yxps,    
          nvl(yjje,0.0) yjje,fkqk ,bz,nvl(sp1,0) sp1,sp2,sp3,sp4,    
          sp5,sp6,sp7,sp8,sp9,sp10 from (      
              select rownum t_row,b.dsdid,a.* from xt_dsd b 
          ,(      
             select ny,rq,zq,area,areaid,winid,qps,xsps,yxps,  
              nvl(yjje,0.0) yjje,fkqk,bz,nvl(sp1,0) sp1,sp2,sp3,sp4, 
              sp5,sp6,sp7,sp8,sp9,sp10 from jfzd a           
              )a where  b.area=a.area(+)  and b.winid=a.winid   条件  
and a.area='GMK'  and a.ny='201201' and a.winid='7'
               
 )order by dsdid,winid)q  where  w.dsdid=q.dsdid(+)    
       group by grouping sets((w.areaid,rownum,w.winid),w.areaid ,'') order by w.areaid,w.winid    
                           
                           
              

Answer 3

看看数据库服务器端有没有报错 ?
检查一下你的jdbc jar与数据库服务器是同一个版本吗

Answer 4

修改前的代码和修改后的代码贴出来对比一下吧，我猜可能是由于拼接的条件导致SQL超过了它允许的最大长度。

Answer 5

可能是你的SQL触发了ORACLE的某个BUG,数据库版本号是什么？
解决方法：
1.安装对应的BUG补丁程序。
2.改写SQL语句，避开BUG。（你可以先从简单的SQL逐步扩展到复杂SQL，看是在哪个环节触发了BUG）