Database Error Messages

OCI-29921

ancillary operator not supported with set view query block

Cause

The ancillary operator matched to a primary operator was outside a UNION ALL view query block while the primary operator was contained in one of the UNION ALL branches.


Action

Define the UNION ALL view query block to contain both the primary and ancillary operators, so that the operators are contained by the query block in the UNION ALL branch, rather than in the query block outside of the view.