Oracle Error ORA-32045: maximum level of recursion reached while executing recursive WITH query

Oracle Error Message

ORA-32045: maximum level of recursion reached while executing recursive WITH query

Reason for the Error

A recursive WITH query reached the maximum level of recursion specified and was stopped.

Solution

Increase the maximum level of recursion or use the CYCLE clause.