java.sql.SQLException

ORA-01722: invalid number

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web7397

  • ORA-01722: invalid number
  • via Oracle Community by Shahzad.H.Magsi, 11 months ago
    ORA-01722: invalid number
  • ORA-01722: invalid number
  • Stack trace

    • java.sql.SQLException: ORA-01722: invalid number at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:913) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:984) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2885) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2926) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:92) at it.csp.llpp.db.QueryHelper.executeQuery(QueryHelper.java:275) at it.csp.soop.entita.opere.TransactionPredisponiSchedePiano.execute(TransactionPredisponiSchedePiano.java:219) at it.csp.llpp.db.ArchivioHelper.executeTransaction(ArchivioHelper.java:88) at it.csp.soop.ui.commands.PredisponiSchedePianoApri.execute(PredisponiSchedePianoApri.java:65) at it.csp.soop.ui.commands.PredisponiSchedeBatchCommand$1.execute(PredisponiSchedeBatchCommand.java:57) at it.csp.straz.BatchCommand$1.run(BatchCommand.java:101) at java.lang.Thread.run(Thread.java:534)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 9 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    76 more bugmates