Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-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.