Oracle Error PLS-00210: an OTHERS clause is required in this CASE statement

Oracle Error Message

PLS-00210: an OTHERS clause is required in this CASE statement

Reason for the Error

Unless the clauses of a CASE statement mention all values of the type of the selecting expression, an OTHERS clause must be provided as the last clause of the CASE statement. It is impossible to cover all values of type INTEGER (or NUMBER), so an OTHERS clause is always required when the expression following the keyword CASE is of type INTEGER (or NUMBER).

Solution

None