Oracle Error ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

Oracle Error Message

ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

Reason for the Error

NULL was given as input to the powermultiset or COLLECT function.

Solution

Give a non-null value as input