Monday, 8 December 2014

ORA-32486: unsupported operation in recursive branch of recursive WITH clause

ORA-32486 unsupported operation in recursive branch of recursive WITH clause

Cause:  Query written with the unsupported operation.
Action:  The recursive component of the UNION ALL in a recursive WITH clause element used an operation that was currently not supported. 
             The following should not be used in the recursive branch of the UNION ALL operation: GROUP BY, DISTINCT, MODEL, grouping sets.


No comments:

Post a Comment