Getting error : ORA-01719: outer join operator (+) not allowed in operand of OR or IN

Vrinda Choraria

We encountered an error with the following query:

AND ((items.inventory_item_id is not null

AND items.inventory_item_id = sod.inventory_item_id(+))

OR items.inventory_item_id is null)

As Oracle Database 19.25 now adheres to the ANSI standard, which prohibits the use of partial outer joins with the ORand IN operators, we updated the query as follows:

AND ((items.inventory_item_id is not null

AND items.inventory_item_id = sod.inventory_item_id(+))

OR items.inventory_item_id(+) is null)

The change is as per example shared to us

However, we are still getting the same error. Can someone please help.

Thanks!

Gianni Ceresa

Hi,

Your request isn't about Publisher, but is a SQL question. You should consider posting in forums dedicated to that, for example https://forums.oracle.com/ords/apexds/domain/dev-community/category/sql_and_pl_sql .

Also, did you check https://docs.oracle.com/en/error-help/db/ora-01719/?r=19c ?