My Oracle Support Banner

ODI 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 and later
Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


Having an Oracle Data Integrator (ODI)  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

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




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.