“ORA-30563: outer join operator (+) not allowed in select-list, CONNECT BY, or START WITH” is Received When Executing an ODI Interface Which Performs an Outer Join With Extraction Condition
Last updated on APRIL 12, 2016
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
When running an interface/mapping, which is intended to perform an outer join with two tables and has an extraction condition, the following error occurs.
Example of extraction conditions:
col_name in ( select col_name from table_name)
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