Oracle Error Message
ORA-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element
Reason for the Error
The recursive component of the UNION ALL in a recursive WITH clause element referenced the recursive query name more than once. Only one reference to the recursive query name is allowed in the recursive branch of a recursive WITH clause element.
Solution
Rewrite the query using only one reference to the recursive query name in the recursive branch of the recursive WITH clause element.
