Oracle Error ORA-32480: SEARCH and CYCLE clauses can only be specified for recursive WITH clause elements

Oracle Error Message

ORA-32480: SEARCH and CYCLE clauses can only be specified for recursive WITH clause elements

Reason for the Error

A SEARCH or a CYCLE clause was specified for a WITH clause element that was not recursive.

Solution

Remove the SEARCH or CYCLE clause, or add recursion to the WITH clause element.