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

Cause: 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).

Action: No action required since CASE statement not supported in releases 1.x,2.x, or 3.x.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/