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.