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 |