The follow table includes a list of SQL States that are used by the i-net Oracle JDBC drivers and their meanings.
| SqlState | Vendor Code | Description |
|---|---|---|
| 21S01 | 913, 947 | insert value list does not match column list |
| 22001 | 1401, 1406 | data transaction / value out of range |
| 22003 | 1426, 1438, 1455, 1457 | numeric value out of range |
| 22012 | 1476 | division by zero |
| 23000 | 1, 2290, 2291, 2292, 2293, 2294, 2295, 2296, 2297, 2298, 2299 | integrity constraint violation |
| 37000 | 900, 923 | invalid SQL statement |
| S0001 | 955 | name is already used by an existing object |
| S0002 | 942 | table or view does not exist |
| S0021 | 1430 | column being added already exists in table |
| S0022 | 904 | column not found |
| S1000 | general error |