ORA-32487
unsupported join in recursive WITH query
Cause
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.
Action
Rewrite the query without the unsupported join operation.
ORA-32487
unsupported join in recursive WITH query
Cause
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.
Action
Rewrite the query without the unsupported join operation.
ORA-32487
unsupported join in recursive WITH query
Cause
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.
Action
Rewrite the query without the unsupported join operation.
