java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected at oracle.jdbc.dbaccess.DBError.throwSqlExceptionDBError.java:168)

Oracle Community | 807549 | 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

    JVM conflicts.......URGENT, please

    Oracle Community | 1 decade ago | 807549
    java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected at oracle.jdbc.dbaccess.DBError.throwSqlExceptionDBError.java:168)
  2. 0

    Problems creating a spatial index

    Oracle Community | 2 decades ago | 102159
    java.sql.SQLException: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine ORA-13011: value is out of range ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 7 ORA-06512: at line 1at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
  3. 0

    Strings > 4000 to CLOB conversion using hibernate

    Stack Overflow | 8 years ago
    java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested</p> <pre><code> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle8,blob, Java and more than 4000 bytes

    Google Groups | 2 decades ago | Bjarte Brandt
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a L ONG column
  6. 0

    Problems again on large objects with Oracle JDBC Thin

    Google Groups | 2 decades ago | Fabrice Delhoste
    java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable

    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-01858: a non-numeric character was found where a numeric was expected at oracle.jdbc.dbaccess.DBError.throwSqlExceptionDBError.java:168)

      at oracle.jdbc.ttc7.TTIoer.processError()
    2. oracle.jdbc.ttc7
      TTC7Protocol.parseExecuteFetch
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
      2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
      3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
      4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
      4 frames
    3. Oracle jdbc
      OraclePreparedStatement.executeUpdate
      1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
      2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
      3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
      4 frames
    4. Unknown
      frmCadCargo$4.actionPerformed
      1. clsCargo.insere(clsCargo.java:514)
      2. frmCadCargo.registraDados(frmCadCargo.java:462)
      3. frmCadCargo.access$100(frmCadCargo.java:29)
      4. frmCadCargo$4.actionPerformed(frmCadCargo.java:261)
      4 frames
    5. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      4. javax.swing.DefaultButtonModel.setPressed(Unknown Source)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
      6. java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
      7. java.awt.Component.processMouseEvent(Unknown Source)
      8. java.awt.Component.processEvent(Unknown Source)
      9. java.awt.Container.processEvent(Unknown Source)
      10. java.awt.Component.dispatchEventImpl(Unknown Source)
      11. java.awt.Container.dispatchEventImpl(Unknown Source)
      12. java.awt.Component.dispatchEvent(Unknown Source)
      13. java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      14. java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      15. java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      16. java.awt.Container.dispatchEventImpl(Unknown Source)
      17. java.awt.Window.dispatchEventImpl(Unknown Source)
      18. java.awt.Component.dispatchEvent(Unknown Source)
      19. java.awt.EventQueue.dispatchEvent(Unknown Source)
      20. java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
      21. java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      22. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      23. java.awt.EventDispatchThread.run(Unknown Source)
      23 frames