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

Oracle Community | 2945829 | 2 years ago
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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
      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