Oracle Error PLS-00605: set operators are not yet supported as an argument to a MULTISET operator

Oracle Error Message

PLS-00605: set operators are not yet supported as an argument to a MULTISET operator

Reason for the Error

A set operator was used in a subquery that was the argument to a MULTISET operator.

Solution

Rewrite your SQL statement so that it does not use a set operator in the subquery that is the argument to the MULTISET operator.