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

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

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

Action: Change at least one operand in the COALESCE expression to be