My Oracle Support Banner

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 JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
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!


In this Document
Goal
Solution
References

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