A Mapping Upgraded From ODI 11g To ODI 12.2.1.1.0 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 12.2.1.1.0 to 12.2.1.1.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

A Mapping upgraded from Oracle Data Integrator (ODI) 11g to ODI 12.2.1.1.0 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.

Changes

 

Cause

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