java.sql.SQLException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER

Oracle Community | 528945 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Sync Error in lite 10g.

    Oracle Community | 1 decade ago | 528945
    java.sql.SQLException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER
  2. 0

    Oracle Lite Sync error

    Oracle Community | 1 decade ago | 528945
    java.sql.SQLException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER
  3. 0

    Deployment error ( ORA - 06550 )

    Oracle Community | 1 decade ago | 423902
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'CONS_EXT.SET_CURR_CLIENT' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored ORA-06550: line 1, column 38: PLS-00201: identifier 'CONS_EXT.SET_CURR_DEVICE' must be declared ORA-06550: line 1, column 38: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Mobile Server Error: java.sql.SQLException: ORA-00942: table or view does n

    Oracle Community | 10 years ago | CEG
    java.sql.SQLException: ORA-00942: table or view does not exist
  6. 0

    ora-00904 invalid column name

    Oracle Community | 9 years ago | 512952
    java.sql.SQLException: ORA-00904: invalid column name

  1. rp 1 times, last 2 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-00932: inconsistent datatypes: expected DATE got NUMBER

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeUpdate
    1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2077)
    2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1987)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2704)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:458)
    4 frames
  5. oracle.lite.sync
    ThreadPool$PoolTask.run
    1. oracle.lite.sync.Subscription.execPrepUpdate(Unknown Source)
    2. oracle.lite.sync.DmlProcessorM.executeInsertUpdate(Unknown Source)
    3. oracle.lite.sync.DmlProcessorM.executeInsertUpdate(Unknown Source)
    4. oracle.lite.sync.DmlProcessorDB.reExecuteDml(Unknown Source)
    5. oracle.lite.sync.DmlProcessorDB.flushIs(Unknown Source)
    6. oracle.lite.sync.HeliosSession.startSession(Unknown Source)
    7. oracle.lite.sync.resume.Client$1.run(Unknown Source)
    8. oracle.lite.sync.resume.ThreadPool$PoolTask.run(Unknown Source)
    8 frames