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.
OCI-29921
Ancillary operator not supported with set view query block
Cause
Outer view query block contains ancillary operator and view query block contains union all.
Action
Define the union-all view query to contain the primary and ancillary query terms. i.e. have the operators within the view definition rather than in the query outside the view.
OCI-29921
Ancillary operator not supported with set view query block
Cause
Outer view query block contains ancillary operator and view query block contains union all.
Action
Define the union-all view query to contain the primary and ancillary query terms. i.e. have the operators within the view definition rather than in the query outside the view.