"ORA-00907: missing right parenthesis" Signaled From ODI 220.127.116.11.0 Generated Flawed Outer-join SQL Code
(Doc ID 2178891.1)
Last updated on APRIL 30, 2021
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 to 22.214.171.124.99 [Release 11gR1]
Information in this document applies to any platform.
The Interfaces that worked fine with ODI 126.96.36.199 now generates invalid outer join SQL code with ODI 188.8.131.52.0.
Below is a snippet of the WHERE clause generated SQL code in a simulation execution of the interface in ODI 184.108.40.206:
The ODI 220.127.116.11.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