Oracle Error ORA-06592: CASE not found while executing CASE statement

Oracle Error Message

ORA-06592: CASE not found while executing CASE statement

Reason for the Error

A CASE statement must either list all possible cases or have an else clause.

Solution

Add all missing cases or an else clause.