Listing of SQLSTATE class codes

Edit online

This table provides a list of general SQLSTATE classes. Each class links to a list of the more specific SQLSTATE codes that comprise that class.

Table 1. SQLSTATE Class Codes
Class code Meaning Subcodes
00 Unqualified Successful Completion Table 1
01 Warning Table 2
02 No Data Table 3
07 Dynamic SQL Error Table 4
08 Connection Exception Table 5
09 Triggered Action Exception Table 6
0A Feature Not Supported Table 7
0E Invalid Schema Name List Specification Table 8
0F Invalid Token Table 9
0K Resignal When Handler Not Active Table 10
0N SQL/XML Mapping Error Table 11
0W Prohibited Statement Encountered During Trigger Table 12
0Z Diagnostics Exception Table 13
10 XQuery Error Table 14
20 Case Not Found for Case Statement Table 15
21 Cardinality Violation Table 16
22 Data Exception Table 17
23 Constraint Violation Table 18
24 Invalid Cursor State Table 19
25 Invalid Transaction State Table 20
26 Invalid SQL Statement Identifier Table 21
27 Triggered Data Change Violation Table 22
28 Invalid Authorization Specification Table 23
2D Invalid Transaction Termination Table 24
2E Invalid Connection Name Table 25
2F SQL Function Exception Table 26
33 Invalid SQL Descriptor Name Table 27
34 Invalid Cursor Name Table 28
35 Invalid Condition Number Table 29
36 Cursor Sensitivity Exception Table 30
38 External Function Exception Table 31
39 External Function Call Exception Table 32
3B Savepoint Exception Table 33
3C Ambiguous Cursor Name Table 34
3F Invalid Schema Name Table 35
42 Syntax Error or Access Rule Violation Table 36
44 WITH CHECK OPTION Violation Table 37
46 Java™ Errors Table 38
51 Invalid Application State Table 39
53 Invalid Operand or Inconsistent Specification Table 40
54 SQL or Product Limit Exceeded Table 41
55 Object Not in Prerequisite State Table 42
56 Miscellaneous SQL or Product Error Table 43
57 Resource Not Available or Operator Intervention Table 44
58 System Error Table 45
5UA Common Utilities and Tools Table 46