Oracle Error Message
ORA-32487: unsupported join in recursive WITH query
Reason for the Error
The recursive component of a recursive WITH clause element contained one of the following:
– A LEFT OUTER join where the right side was the recursive query name.
– A RIGHT OUTER join where the left side was the recursive query name.
– A FULL OUTER join involving the recursive query name.
Solution
Rewrite the query without the unsupported join operation.