-- SQLSTATE.SQL generated 17-MAY-2011 10:40:02.85
-- Copyright (c) 2000, 2011, Oracle Corporation.  All Rights Reserved.

declare :SQLSTATE_LEN constant integer default 5;

-- success
declare :SQLSTATE_SUCCESS constant char(5) default '00000';

-- warning - generic
declare :SQLSTATE_WARNING constant char(5) default '01000';

-- null value eliminated in set function
declare :SQLSTATE_NULL_ELIM constant char(5) default '01003';

-- string data - right truncation
declare :SQLSTATE_WARN_TRUNC constant char(5) default '01004';

-- no data
declare :SQLSTATE_NO_DATA constant char(5) default '02000';

-- connection name in use
declare :SQLSTATE_CONN_NAME constant char(5) default '08002';

-- connection does not exist
declare :SQLSTATE_CONN_UNKNOWN constant char(5) default '08003';

-- connection failure
declare :SQLSTATE_CONN_FAIL constant char(5) default '08006';

-- trigger action exception
declare :SQLSTATE_TRIG_ERROR constant char(5) default '09000';

-- case not found for case statement
declare :SQLSTATE_CASE_NOELSE constant char(5) default '20000';

-- cardinality violation
declare :SQLSTATE_CARD_VIOLATION constant char(5) default '21000';

-- string data - right truncation
declare :SQLSTATE_DATA_TRUNC constant char(5) default '22001';

-- null value - no indicator parameter
declare :SQLSTATE_DATA_NULL constant char(5) default '22002';

-- numeric value out of range
declare :SQLSTATE_DATA_RANGE constant char(5) default '22003';

-- null value not allowed
declare :SQLSTATE_DATA_NONULL constant char(5) default '22004';

-- error in assignment
declare :SQLSTATE_DATA_ASSIGN constant char(5) default '22005';

-- invalid datetime format
declare :SQLSTATE_DATA_DT_FORMAT constant char(5) default '22007';

-- datetime field overflow
declare :SQLSTATE_DATA_DT_OFLOW constant char(5) default '22008';

-- invalid indicator parameter value
declare :SQLSTATE_DATA_INV_INDICATOR constant char(5) default '22010';

-- substring error
declare :SQLSTATE_DATA_SUBSTR constant char(5) default '22011';

-- division by zero
declare :SQLSTATE_DATA_DIV_ZERO constant char(5) default '22012';

-- datetime field overflow
declare :SQLSTATE_DATA_DTI_OFLOW constant char(5) default '22015';

-- invalid character value for cast
declare :SQLSTATE_DATA_CAST constant char(5) default '22018';

-- invalid limit value
declare :SQLSTATE_DATA_INV_LIMIT constant char(5) default '22020';

-- indicator overflow
declare :SQLSTATE_DATA_IND_OVERFLOW constant char(5) default '22022';

-- invalid parameter value
declare :SQLSTATE_DATA_INV_PARAM constant char(5) default '22023';

-- unterminated C string
declare :SQLSTATE_DATA_C_STRING constant char(5) default '22024';

-- invalid escape sequence
declare :SQLSTATE_DATA_INV_ESCAPE constant char(5) default '22025';

-- trim error
declare :SQLSTATE_DATA_TRIM constant char(5) default '22027';

-- invalid regular expression
declare :SQLSTATE_DATA_INV_REGEXP constant char(5) default '2201B';

-- zero length character string
declare :SQLSTATE_DATA_ZLEN_STRING constant char(5) default '2200F';

-- integrity constraint violation
declare :SQLSTATE_INTEG_CONSTR constant char(5) default '23000';

-- invalid cursor state
declare :SQLSTATE_CURS_INV_STATE constant char(5) default '24000';

-- invalid transaction state
declare :SQLSTATE_TRAN_INV_STATE constant char(5) default '25000';

-- active SQL transaction
declare :SQLSTATE_TRAN_ACTIVE constant char(5) default '25001';

-- read-only SQL transaction
declare :SQLSTATE_TRAN_READONLY constant char(5) default '25006';

-- invalid statement name
declare :SQLSTATE_STMT_INV_NAME constant char(5) default '26000';

-- SQL routine exception
declare :SQLSTATE_ROUT_ERROR constant char(5) default '2F000';

-- function did not execute return statement
declare :SQLSTATE_ROUT_RETURN constant char(5) default '2F005';

-- Oracle Rdb: database specification syntax error
declare :SQLSTATE_DBENV_SYNTAX constant char(5) default '37000';

-- external routine exception
declare :SQLSTATE_ERTN_ERROR constant char(5) default '38000';

-- external routine invocation exception
declare :SQLSTATE_ERTN_CALL_ERROR constant char(5) default '39000';

-- invalid SQLSTATE returned
declare :SQLSTATE_ERTN_INV_SQLSTATE constant char(5) default '39001';

-- null value not allowed
declare :SQLSTATE_ERTN_NULL_INV constant char(5) default '39004';

-- savepoint exception
declare :SQLSTATE_SAVEPOINT_ERROR constant char(5) default '3B000';

-- savepoint exception - invalid specification
declare :SQLSTATE_SAVEPOINT_INVSPEC constant char(5) default '3B001';

-- savepoint exception - too many
declare :SQLSTATE_SAVEPOINT_TOO_MANY constant char(5) default '3B002';

-- savepoint exception - can not use from function or trigger
declare :SQLSTATE_SAVEPOINT_BADLOC constant char(5) default '3B503';

-- syntax error or access rule violation
declare :SQLSTATE_SYNTAX_ERROR constant char(5) default '42000';

-- with check option violation
declare :SQLSTATE_VIEW_CHECK constant char(5) default '44000';

-- invalid SQLSTATE value
declare :SQLSTATE_INV_SQLSTATE constant char(5) default '0H000';

-- Oracle Rdb: deadlock
declare :SQLSTATE_DEADLOCK constant char(5) default 'R1001';

-- Oracle Rdb: lock conflict
declare :SQLSTATE_LOCK_CONFLICT constant char(5) default 'R1002';

-- Oracle Rdb: duplicate value not allowed in index
declare :SQLSTATE_NO_DUP constant char(5) default 'R2000';

-- Oracle Rdb: distibuted transaction id error
declare :SQLSTATE_DIST_TRAN_ID constant char(5) default 'R4000';

-- Oracle Rdb: table is read only
declare :SQLSTATE_RO_TABLE constant char(5) default 'R5000';

-- Oracle Rdb: obsolete metadata
declare :SQLSTATE_OBS_METADATA constant char(5) default 'R6000';

-- Oracle Rdb: table is not un reserving list for transaction
declare :SQLSTATE_UNRES_REL constant char(5) default 'R7000';

-- Oracle Rdb: unspecified error
declare :SQLSTATE_UNSPEC_ERROR constant char(5) default 'RR000';

-- Oracle Rdb: no implicit transaction allowed
declare :SQLSTATE_NOIMP_TRANS constant char(5) default 'S0000';

-- Oracle Rdb: bad context version
declare :SQLSTATE_CTX_BAD_VER constant char(5) default 'S1001';

-- Oracle Rdb: bad context type
declare :SQLSTATE_CTX_BAD_TYPE constant char(5) default 'S1002';

-- Oracle Rdb: bad context length
declare :SQLSTATE_CTX_BAD_LEN constant char(5) default 'S1003';

-- Oracle Rdb: base row was already deleted
declare :SQLSTATE_BASE_ROW_DEL constant char(5) default 'S2000';

-- Oracle Rdb: alias name in not known
declare :SQLSTATE_ALIAS_UNKNOWN constant char(5) default 'S4001';

-- Oracle Rdb: alias name in use
declare :SQLSTATE_ALIAS_USED constant char(5) default 'S4002';

-- Oracle Rdb: bad length
declare :SQLSTATE_BAD_LENGTH constant char(5) default 'S5001';

-- Oracle Rdb: bad scale
declare :SQLSTATE_BAD_SCALE constant char(5) default 'S5002';

-- Oracle Rdb: bad SQL version
declare :SQLSTATE_BAD_VERSION constant char(5) default 'S7000';