What Is the Correct Separator Character to Be Used with the SQL IN Operator when Evaluating an ODI Variable
(Doc ID 973022.1)
Last updated on OCTOBER 02, 2023
Applies to:
Oracle Data Integrator - Version 10.1.3.2.0 to 10.1.3.2.0 [Release 10gR3]Information in this document applies to any platform.
Goal
When using the IN operator in an Oracle Data Integrator (ODI) Package evaluate Variable step, the generated SQL instruction is incorrect when using the standard SQL character (',', comma) for list separation.
The following screenshot indicate values which do not generate correct SQL instructions:
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! |