Using Oracle LONG Datatype Columns In ODI (Doc ID 423992.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.


Goal

The following error is signalled when mapping an Oracle LONG datatype field in an Oracle Data Integrator (ODI) Interface:

ORA-00997 illegal use of LONG datatype

Is it possible to use Oracle LONG columns with ODI?

Solution

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