Database Error Messages

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

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