"ORA-00907: missing right parenthesis" Signalled From ODI 184.108.40.206.0 Generated Flawed Outer-join SQL Code
(Doc ID 2178891.1)
Last updated on OCTOBER 06, 2016
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
The Interfaces that worked fine with ODI 18.104.22.168 now generates invalid outer join SQL code with ODI 22.214.171.124.0.
Below is a snippet of the WHERE clause generated SQL code in a simulation execution of the interface in ODI 126.96.36.199:
The ODI 188.8.131.52.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