Oracle Error PLS-00621: at least one operand in the COALESCE expression must not be NULL

Oracle Error Message

PLS-00621: at least one operand in the COALESCE expression must not be NULL

Reason for the Error

All the operands in the COALESCE expression are the literal NULL.

Solution

Change at least one operand in the COALESCE expression to be non-NULL.