My Oracle Support Banner

Incorrect Column Datatype Set On The 'Create flow table I$' Step Of An ODI Integration Interface (Doc ID 424504.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

The following message is signaled on the Create flow table I$ step when executing an Integration Interface loading data from an Oracle source Datastore into a LDAP target Datastore:

0 : null : java.sql.SQLException: Wrong data type: VARCHAR2 in statement
create table I$_XXX
(
...
IND_UPDATE VARCHAR2(1)
)

Note that:

What is the issue here?

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!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.