SqlStates of the i-net Oracle Server JDBC drivers

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
21S01913, 947insert value list does not match column list
220011401, 1406data transaction / value out of range
220031426, 1438, 1455, 1457numeric value out of range
220121476division by zero
230001, 2290, 2291, 2292, 2293, 2294, 2295, 2296, 2297, 2298, 2299integrity constraint violation
37000900, 923invalid SQL statement
S0001955name is already used by an existing object
S0002942table or view does not exist
S00211430column being added already exists in table
S0022904column not found
S1000 general error

© Copyright 1996 - 2021, i-net software; All Rights Reserved.