java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER at oracle.jdbc.driver.SQLStateMapping.newSQLException (SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(D atabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1189) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper. executeQuery(OraclePreparedStatementWrapper.java:1 491) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XM LPGEN.java:1947) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataS ource(XMLPGEN.java:501) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPG EN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStruc ture(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XML PGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLP GEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGE N.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDa taStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processDa ta(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(D ataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram (JCP4XDODataEngine.java:294)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by User319671, 1 year ago
ORA-00932: inconsistent datatypes: expected DATE got NUMBER at oracle.jdbc.driver.SQLStateMapping.newSQLException (SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(D atabaseError.java:133) at
java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER at oracle.jdbc.driver.SQLStateMapping.newSQLException (SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(D atabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1189) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper. executeQuery(OraclePreparedStatementWrapper.java:1 491) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XM LPGEN.java:1947) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataS ource(XMLPGEN.java:501) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPG EN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStruc ture(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XML PGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLP GEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGE N.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDa taStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processDa ta(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(D ataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram (JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.