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.