"ORA-00907: missing right parenthesis" Signalled From ODI 22.214.171.124.0 Generated Flawed Outer-join SQL Code
Last updated on OCTOBER 06, 2016
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 and later
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.
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 hundreds of Community platforms