SQL Language Guide > SQL Language Guide > Database Procedures, Sessions, Events and Exception handling > Exception Handling in Database Procedures > Predefined Conditions
Was this helpful?
Predefined Conditions
Instead of referencing a specific DBMSERROR or SQLSTATE as its handler condition value, you can specify a predefined condition name.
The following names for commonly encountered exceptions can be used as a shortcut for specifying conditions.
 
Name
SQLSTATE
DBMSERROR NUMBER
CHECK_VIOLATION
23500
 
CONSTRAINT_VIOLATION
235xx
 
DATA_EXCEPTION
22000
 
DATETIME_FORMAT
22007
 
DATETIME_VALUE
22008
 
DEADLOCK
 
4700
FORCE_ABORT
 
4706
LOCK_TIMEOUT
 
4702
NULL_TO_NONULL
 
AD1012 (135186)
NUMERIC_RANGE
22003
 
OUT_OF_LOCKS
 
4703, 4705
REFERENTIAL_VIOLATION
23502, 23505, 23001
 
UNIQUE_VIOLATION
23501
 
ZERO_DIVIDE
22012
 
Last modified date: 12/19/2024