ORA-32042
recursive WITH clause element WITH_clause_name must reference itself directly in one of the UNION ALL branches
- WITH_clause_name: name of the WITH clause element
Cause
The specified recursive WITH clause element referred to itself indirectly, for example through a subquery or view, which is not supported.
Action
Rewrite the recursive WITH clause element to refer to itself directly in the FROM clause of one of the UNION ALL branches.
ORA-32042
recursive WITH clause must reference itself directly in one of the UNION ALL branches
Cause
A WITH clause query referred to itself (recursive) indirectly, such as through a subquery or view.
Action
Rewrite the recursive WITH clause query to refer to itself directly in the FROM clause of one of the UNION ALL branches.
ORA-32042
recursive WITH clause must reference itself directly in one of the UNION ALL branches
Cause
A WITH clause query referred to itself (recursive) indirectly, such as through a subquery or view.
Action
Rewrite the recursive WITH clause query to refer to itself directly in the FROM clause of one of the UNION ALL branches.
