Oracle Error ORA-32044: cycle detected while executing recursive WITH query

Oracle Error Message

ORA-32044: cycle detected while executing recursive WITH query

Reason for the Error

A recursive WITH clause query produced a cycle and was stopped in order to avoid an infinite loop.

Solution

Rewrite the recursive WITH query to stop the recursion or use the CYCLE clause.