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

Oracle Community | 2945829 | 1 year ago
  1. 0

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

    Oracle Community | 1 year 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