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



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

Answer / guest

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: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30754: column or table string stores objects of only one type

1 Answers  


ORA-31452: invalid value string for parameter, expecting: Y or N

1 Answers  


ORA-22977: missing or invalid attribute

1 Answers  


QSM-01021: materialized view, string, not found in the hint list

1 Answers  


PCB-00223: Undeclared variable "string"

1 Answers  






ORA-13622: The recommendation annotation string is invalid.

1 Answers  


NID-00602: Could not allocate number bytes for "string"

1 Answers  


ORA-14007: missing LESS keyword

1 Answers  


ORA-13514: Metric Capture too close to last capture, group string

1 Answers  


DRG-50953: Unable to determin section name

1 Answers  


PCC-02414: This attribute does not exist in the specified Object

1 Answers  


ORA-01761: DML operation does not map to a unique table in the join

1 Answers  


Categories