My Oracle Support Banner

The Use Of Bounded Variables In SQL DDL Statements Result In Uncorrect Behavior (Doc ID 424149.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.18 to 3.2.03.18 [Release 3.2.03]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

An Oracle Data Integrator (Sunopsis) Procedure/Knowledge Module command line executes a SELECT statement on the Source tab. The result of this query is used on the Destination tab in order to perform a DDL statement (such as DROP, ALTER, CREATE, ...).

Only the first line of the result set generated by the SQL query on the Source tab is taken into account.

Example of the code on the Source tab:

How is it possible to make sure that the Procedure/Knowledge Module takes the entire result set into account?

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!


In this Document
Goal
Solution

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