My Oracle Support Banner

ODI 12c: Unable To Insert Data from Higher Oracle Database Version (such as 19c) into Lower Oracle Databse Version (such as 11g) (Doc ID 3013962.1)

Last updated on APRIL 08, 2024

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) 12c Mapping is designed to read a VARCHAR2(4500) column from a source Oracle 19c table, and write into a target Oracle 11g table.

The execution of Mapping fails while processing the above VARCHAR2 data, and error message such as the following one is received:

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.