OCI-32040
missing UNION ALL in recursive WITH clause element WITH_clause_name
- WITH_clause_name: name of the WITH clause element
Cause
The specified WITH clause element referred to itself (recursive) but did not use a UNION ALL operation.
Action
Rewrite the recursive WITH clause element to use a UNION ALL operation.
OCI-32040
recursive WITH clause must use a UNION ALL operation
Cause
A WITH clause query referred to itself (recursive) but did not use a UNION ALL operation in its definition query.
Action
Rewrite the recursive WITH clause query to use a UNION ALL operation.
OCI-32040
recursive WITH clause must use a UNION ALL operation
Cause
A WITH clause query referred to itself (recursive) but did not use a UNION ALL operation in its definition query.
Action
Rewrite the recursive WITH clause query to use a UNION ALL operation.