My Oracle Support Banner

ORA-01719 Error is Reported for a Query After Upgrade to 19c (Doc ID 2856485.1)

Last updated on MARCH 22, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After updating a database from 12.1.0.2 to 19.14, the applications gets the error "ORA-01719: outer join operator (+) not allowed in operand of OR or IN" for certain selects.

-  As per the details in <Note 2740441.1> - ORA-01719 Error for a Select Query in 19c Database, attempting to use the suggested workaround:

alter system set "_fix_control" = '28012754:0';

    But this does not fix the error.

-  Setting optimizer_features_enable to 12.1.0.2, helps to avoid the error. Any value for OFE above 12.1.0.2 reports the same error.

-  Applying <Patch 32786308> does not help.

-  Setting the below fix_control also does not help:

alter session set "_fix_control"="31009032:on";

-  Stack trace from the error trace file lists the below functions:

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.