ava.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Oracle Community | 2945829 | 2 years 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

    I am Using Below Query in Project variable in ODI to fetch the error message with the current session :

    Oracle Community | 2 years ago | 2945829
    ava.sql.SQLSyntaxErrorException: ORA-01722: invalid number

    Root Cause Analysis

    1. ava.sql.SQLSyntaxErrorException

      ORA-01722: invalid number

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      T4CTTIfun.receive
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
      4 frames