My Oracle Support Banner

Restrictions Concerning Commands Used on the Target Tab of an ODI Procedure or Knowledge Module Step (Doc ID 555013.1)

Last updated on DECEMBER 07, 2023

Applies to:

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

Goal

An Oracle Data Integrator (ODI) Procedure or Knowledge Module step executes a SELECT statement on the 'Command On Source' tab.

The result of this query is used on the 'Command on Target' tab.

This is called the Bind mechanism in ODI.

For example, one Procedure step with:

Command on Source:

Does the table under Command on Target tab always need to be prefixed with its physical schema name?

Do we always use the ":" to bind the column alias from Command on Source tab?

Solution

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.