The Use Of Bounded Variables In SQL DDL Statements Result In Uncorrect Behavior
(Doc ID 424149.1)
Last updated on FEBRUARY 28, 2023
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 |