Oracle Error ORA-22903: MULTISET expression not allowed

Oracle Error Message

ORA-22903: MULTISET expression not allowed

Reason for the Error

MULTISET expressions are allowed only inside a CAST to a nested table or VARRAY type.

Solution

put the MULTISET(subquery) expression inside a CAST to a nested table or VARRAY type.