SQLSTATE Coding Scheme
This table shows the classes predefined by SQL92.
| Class | Condition |
|---|---|
| 00 | successful completion |
| 01 | warning |
| 02 | no data |
| 07 | dynamic SQL error |
| 08 | connection exception |
| 0A | feature not supported |
| 21 | cardinality violation |
| 22 | data exception |
| 23 | integrity constraint violation |
| 24 | invalid cursor state |
| 25 | invalid transaction state |
| 26 | invalid SQL statement name |
| 27 | triggered data change violation |
| 28 | invalid authorization specification |
| 2A | direct SQL syntax error or access rule violation |
| 2B | dependent privilege descriptors still exist |
| 2C | invalid character set name |
| 2D | invalid transaction termination |
| 2E | invalid connection name |
| 33 | invalid SQL descriptor name |
| 34 | invalid cursor name |
| 35 | invalid condition number |
| 37 | dynamic SQL syntax error or access rule violation |
| 3C | ambiguous cursor name |
| 3D | invalid catalog name |
| 3F | invalid schema name |
| 40 | transaction rollback |
| 42 | syntax error or access rule violation |
| 44 | with check option violation |
| HZ | remote database access |
Leave a comment