Oracle Error ORA-22166: collection is empty

Oracle Error Message

ORA-22166: collection is empty

Reason for the Error

Given collection is empty.

Solution

Test if collection is empty prior to invoking this function.