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!

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

What Is the Correct Separator Character to Be Used with the SQL IN Operator when Evaluating an ODI Variable (Doc ID 973022.1)

Applies to:

Goal

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!