Database Error Messages

ORA-32041

UNION ALL operation in recursive WITH clause element WITH_clause_name must have only two branches.
  • WITH_clause_name: name of the WITH clause element

Cause

The specified WITH clause element referred to itself (recursive) but used a UNION ALL operation with more than two branches, which is not supported.


Action

Rewrite the recursive WITH clause element to use only two branches in the UNION ALL operation.