My Oracle Support Banner

ODI-1228 Error When We Set Cross Technology Foreign Key Relationship In ODI Datastores (Doc ID 1454769.1)

Last updated on JUNE 16, 2022

Applies to:

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


You have one table <TABLE1> from Oracle database (for example, <DBSCHEMA>.<TABLE1>), and another table <TABLE2> from a flat file.

When you set a reference (Foreign Key relationship) between these two Datastores in Oracle Data Integrator (ODI), and use the <TABLE1> Datastore as target in a Mapping / Integration Interface, the execution will fail  with:

ODI-1228: Task EMP (Control) fails on the target ORACLE connection <DBSCHEMA_CONNECTION_NAME>.
Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 1



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

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