My Oracle Support Banner

ODI Incorrectly Generates Empty String for Old Outer Join "(+)" Syntax (Doc ID 2767704.1)

Last updated on JULY 30, 2024

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 to 12.2.1.4.210321 [Release 12c]
Information in this document applies to any platform.

Symptoms

Using ODI 12.2.1.4.210108, an Oracle Data Integrator (ODI) customized Knowledge Module (KM) is used to generate the old outer join syntax (+).

If the KM code only contains "(+)" to concatenate, ODI generates an empty string.


This worked in some older release 12.1.3 or 12.2.1. The same stopped working in 12.2.1.2.6 and later.

Executions with this syntax fail with the following error:

 

 

Cause

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
Symptoms
Cause
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.