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-06755: TLI Driver: cannot close transport endpoint

1 Answers  


RMAN-08531: channel string: proxy copy string is string in media management catalog

1 Answers  


DRG-12226: a field section named string already exists in this section group

1 Answers  


ORA-16093: dependent archive log destination is not LGWR-enabled

1 Answers  


ORA-38725: specified name "string" does not match actual "string"

1 Answers  






ORA-07580: spstp: $GETJPIW failure

1 Answers  


ORA-01214: MAXLOGHISTORY may not exceed string

1 Answers  


ORA-07571: szrfc: $FIND_HELD failure

1 Answers  


ORA-02261: such unique or primary key already exists in the table

1 Answers  


ORA-15125: ASM file name 'string' contains an invalid template name

1 Answers  


ORA-29300: ORACLE error, tablespace point-in-time recovery

1 Answers  


PCC-02438: Arrays of collection objects are not allowed

1 Answers  


Categories