Class 22 - Class 24

SQLSTATE Value	Description
Class 22 - Data exception
22000	DATA_EXCEPTION
2200E	ARRAY_ELEMENT_ERROR
2202E	ARRAY_SUBSCRIPT_ERROR
22021	Character not in repertoire (CHARACTER_NOT_IN_REPERTOIRE)
22008	Datetime field overflow (DATETIME_FIELD_OVERFLOW)
22020	DATETIME_VALUE_OUT_OF_RANGE
22012	Division by zero (DIVISION_BY_ZERO)
22005	Error in assignment (ERROR_IN_ASSIGNMENT)
2200B	Escape character conflict (ESCAPE_CHARACTER_CONFLICT)
22022	Indicator overflow (INDICATOR_OVERFLOW)
22015	Interval field overflow (INTERVAL_FIELD_OVERFLOW)
2201E	Invalid argument for logarithm (INVALID_ARGUMENT_FOR_LOGARITHM)
22014	Invalid argument for NTILE function (INVALID_ARGUMENT_FOR_NTILE_FUNCTION)
22016	Invalid argument for N value function (INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION)
2201F	Invalid argument for power function (INVALID_ARGUMENT_FOR_POWER_FUNCTION)
2201G	Invalid argument for width bucket function (INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION)
22018	Invalid character value for CAST (INVALID_CHARACTER_VALUE_FOR_CAST)
22007	Invalid datetime format (INVALID_DATETIME_FORMAT)
22019	Invalid escape character (INVALID_ESCAPE_CHARACTER)
2200D	Invalid escape octet (INVALID_ESCAPE_OCTET)
22025	Invalid escape sequence (INVALID_ESCAPE_SEQUENCE)
22P06	Nonstandard use of escape character (NONSTANDARD_USE_OF_ESCAPE_CHARACTER)
22010	Invalid indicator parameter value (INVALID_INDICATOR_PARAMETER_VALUE)
22023	Invalid parameter value (INVALID_PARAMETER_VALUE)
2201B	Invalid regular expression (INVALID_REGULAR_EXPRESSION)
2201W	Invalid row count in LIMIT clause (INVALID_ROW_COUNT_IN_LIMIT_CLAUSE)
2201X	Invalid row count in result set clause (INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE)
2202H	Invalid sample parameter (INVALID_TABLESAMPLE_ARGUMENT)
2202G	Invalid sample repeat (INVALID_TABLESAMPLE_REPEAT)
22009	Invalid time zone displacement value (INVALID_TIME_ZONE_DISPLACEMENT_VALUE)
2200C	Invalid use of escape character (INVALID_USE_OF_ESCAPE_CHARACTER)
2200G	Most specific type mismatch (MOST_SPECIFIC_TYPE_MISMATCH)
22004	Null value not allowed (NULL_VALUE_NOT_ALLOWED)
22002	Null value cannot be used as the indicator parameter(NULL_VALUE_NO_INDICATOR_PARAMETER)
22003	Numeric value out of range (NUMERIC_VALUE_OUT_OF_RANGE)
22017	DOP value out of range (DOP_VALUE_OUT_OF_RANGE)
22026	String data length mismatch (STRING_DATA_LENGTH_MISMATCH)
22028	Regular expression mismatch (REGEXP_MISMATCH)
22001	String data right truncation (STRING_DATA_RIGHT_TRUNCATION)
22011	Substring error (SUBSTRING_ERROR)
22027	Trim error (TRIM_ERROR)
22024	Unterminated C string (UNTERMINATED_C_STRING)
2200F	Zero-length character string (ZERO_LENGTH_CHARACTER_STRING)
22P01	Floating point exception (FLOATING_POINT_EXCEPTION)
22P02	Invalid text representation (INVALID_TEXT_REPRESENTATION)
22P03	Invalid binary representation (INVALID_BINARY_REPRESENTATION)
22P04	Incorrect copy file format (BAD_COPY_FILE_FORMAT)
22P05	Untranslatable character (UNTRANSLATABLE_CHARACTER)
22P06	Memory query failure (CACHE_LOOKUP_FAILED)
22P07	Failed to read the file (FILE_READ_FAILED)
22P08	Failed to obtain data (FETCH_DATA_FAILED)
2200L	Not XML file (NOT_AN_XML_DOCUMENT)
2200M	Invalid XML file (INVALID_XML_DOCUMENT)
2200N	Invalid XML content (INVALID_XML_CONTENT)
2200O	Invalid XML error information (INVALID_XML_ERROR_CONTEXT)
2200S	Invalid XML comment (INVALID_XML_COMMENT)
2200T	Invalid XML processing instruction (INVALID_XML_PROCESSING_INSTRUCTION)
2200X	RELATION close error (RELATION_CLOSE_ERROR)
2200Z	ENCRYPED_COLUMN_WRONG_DATA
Class 23 - Integrity constraint violation
23000	Integrity constraint violation (INTEGRITY_CONSTRAINT_VIOLATION)
23001	Restrict violation (RESTRICT_VIOLATION)
23502	Not null violation (NOT_NULL_VIOLATION)
23503	Foreign key violation (FOREIGN_KEY_VIOLATION)
23505	Uniqueness violation (UNIQUE_VIOLATION)
23514	CHECK violation (CHECK_VIOLATION)
23P01	Exclusion violation (EXCLUSION_VIOLATION)
Class 24 - Invalid cursor state
24000	Invalid cursor state (INVALID_CURSOR_STATE)