In this post, you’ll learn more about the Oracle ErrorPLS-00605: set operators are not yet supported as an argument to a MULTISET operator with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00605: set operators are not yet supported as an argument to a MULTISET operator
Reason for the Error PLS-00605: set operators are not yet supported as an argument to a MULTISET operator
A set operator was used in a subquery that was the argument to a MULTISET operator.
How to fix the Error PLS-00605: set operators are not yet supported as an argument to a MULTISET operator ?
You can fix this error in Oracle by following the below steps
Rewrite your SQL statement so that it does not use a set operator in the subquery that is the argument to the MULTISET operator.