"ORA-00907: missing right parenthesis" Signaled From ODI 18.104.22.168.0 Generated Flawed Outer-join SQL Code
(Doc ID 2178891.1)
Last updated on FEBRUARY 14, 2019
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.99 [Release 11gR1]
Information in this document applies to any platform.
The Interfaces that worked fine with ODI 188.8.131.52 now generates invalid outer join SQL code with ODI 184.108.40.206.0.
Below is a snippet of the WHERE clause generated SQL code in a simulation execution of the interface in ODI 220.127.116.11:
The ODI 18.104.22.168.0 generated code that contains the second example fails with a "ORA-00907: missing right parenthesis" syntax error.
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