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-27092: size of file exceeds file size limit of the process

1 Answers  


NNO-00257: warning: cannot get serial number from region store

1 Answers  


ORA-24815: Invalid character set form

1 Answers  


ORA-25103: NOPARALLEL option can only be used with ALTER INDEX REBUILD

1 Answers  


ORA-07304: ksmcsg: illegal redo buffer size.

1 Answers  






ORA-29305: cannot point-in-time recover tablespace 'string'

1 Answers  


RMAN-06378: List of Backup Sets

1 Answers  


NID-00100: Cannot open datafile "string"

1 Answers  


ORA-23369: value of "string" argument cannot be null

1 Answers  


ORA-01350: must specify a tablespace name

1 Answers  


NNL-00229: Request-processing delay is now disabled

1 Answers  


ORA-28668: cannot reference mapping table of an index-organized table

1 Answers  


Categories