My Oracle Support Banner

ODI 12.2.1.4 Mapping Writing to Target XML Creates the C$ Table with Incorrect Data Types when Oracle External Database Is Used (Doc ID 2994682.1)

Last updated on DECEMBER 22, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.4.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

Having an Oracle Data Integrator (ODI) 12.2.1.4  Mapping that writes to a target XML Datastore.

When Oracle external database is used on the XML Data Server, the C$ table is created with incorrect data types.

For example, when the external database used is Oracle, the data types in the C$ table are:

VARCHAR -- instead of VARCHAR2
NUMERIC -- instead of NUMBER
LOMGVARCHAR -- instead of CLOB
etc

In fact, the data types used are from the XML technology instead of the technology of the Oracle external database.

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.