A Mapping Upgraded From ODI 11g To ODI Fails With "ORA-01790" While Converting a NUMERIC Value to VARCHAR2

(Doc ID 2228406.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


A Mapping upgraded from Oracle Data Integrator (ODI) 11g to ODI fails while converting a NUMERIC value to VARCHAR2, and signals:

Caused By: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

The mentioned issue was never caught on ODI 11g, but was becoming an issue after upgrading to 12c.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms