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: None
PLS-00211
Custom Search


More Oracle errors
ORA-29329Table not of type XMLType
ORA-44413Invalid ACL: Security class of parent ACL must be an ancestor of security class of child ACL
TNS-00122Missing ADDRESS(es) in TNSNET.ORA file
CLSS-00100configuration data access failed for key string
ORA-27041unable to open file
CLSR-00520No service member found
ORA-24196access the message in a wrong access mode
LFI-01002Unable to read line from file.
LPX-00103document structure does not match DTD
ORA-02004security violation
PCC-00141Thread Safety is not implemented in this precompiler
ORA-14304List partitioning method expects a single partitioning column
ORA-27451string cannot be NULL
DRG-13606start_hit_num is not specified or out of valid range number..number
NNL-00206No reload check currently scheduled
ORA-39786Number of columns does not match between export and import databases
ORA-01174DB_FILES is string buts needs to be string to be compatible
NPL-00308requested ASN.1 class string does not match received class string
TNS-12234TNS:Redirect to destination
DIA-48167invalid argument for checking ADR initialization




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
PLS-00210an OTHERS clause is required in this CASE statement