PLS-00617: at least one result in the CASE expression must not be NULL

PLS-00617: at least one result in the CASE expression must not be NULL

Cause: All the results in the CASE expression are the literal NULL.

Action: Change at least one result in the CASE expression to be non-NULL.