Here's a list of exception conditions defined in the SQL specification (ISO/IEC 9075-2:2011 (Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)):
- SQL routine exception — function executed no return statement - SQL routine exception — modifying SQL-data not permitted - SQL routine exception — prohibited SQL-statement attempted - SQL routine exception — reading SQL-data not permitted - ambiguous cursor name - attempt to assign to nonupdatable column - attempt to assign to ordering column - cardinality violation - connection exception — SQL-client unable to establish SQL-connection - connection exception — SQL-server rejected establishment of SQL-connection - connection exception — connection does not exist - connection exception — connection failure - connection exception — connection name in use - connection exception — transaction resolution unknown - cursor sensitivity exception — request failed - cursor sensitivity exception — request rejected - data exception — array data, right truncation - data exception — array element error - data exception — attempt to replace a zero-length string - data exception — character not in repertoire - data exception — datetime field overflow - data exception — division by zero - data exception — error in assignment - data exception — interval field overflow - data exception — invalid XQuery option flag - data exception — invalid XQuery regular expression - data exception — invalid argument for NTH_VALUE function - data exception — invalid argument for NTILE function - data exception — invalid argument for natural logarithm - data exception — invalid argument for power function - data exception — invalid argument for width bucket function - data exception — invalid character value for cast - data exception — invalid datetime format - data exception — invalid escape character - data exception — invalid interval format - data exception — invalid parameter value - data exception — invalid regular expression - data exception — invalid row version - data exception — invalid sample size - data exception — invalid time zone displacement value - data exception — invalid use of escape character - data exception — most specific type mismatch - data exception — noncharacter in UCS string - data exception — null row not permitted in table - data exception — null value in array target - data exception — null value not allowed - data exception — null value substituted for mutator subject parameter - data exception — null value, no indicator parameter - data exception — numeric value out of range - data exception — sequence generator limit exceeded - data exception — string data, right truncation - data exception — substring error - data exception — trim error - data exception — unterminated C string; - data exception — zero-length character string - dependent privilege descriptors still exist - diagnostics exception — maximum number of stacked diagnostics areas exceeded - dynamic SQL error — cursor specification cannot be executed - dynamic SQL error — data type transform function violation - dynamic SQL error — invalid DATA target - dynamic SQL error — invalid DATETIME_INTERVAL_CODE - dynamic SQL error — invalid LEVEL value - dynamic SQL error — invalid descriptor count - dynamic SQL error — invalid descriptor index - dynamic SQL error — prepared statement not a cursor specification - dynamic SQL error — restricted data type attribute violation - dynamic SQL error — undefined DATA value - dynamic SQL error — using clause does not match dynamic parameter specifications - dynamic SQL error — using clause does not match target specifications - dynamic SQL error — using clause required for dynamic parameters - dynamic SQL error — using clause required for result fields - external routine exception — containing SQL not permitted - external routine exception — modifying SQL-data not permitted - external routine exception — prohibited SQL-statement attempted - external routine exception — reading SQL-data not permitted - external routine invocation exception — null value not allowed - feature not supported — multiple server transactions - integrity constraint violation — restrict violation - invalid SQL descriptor name - invalid SQL statement identifier - invalid SQL statement name - invalid SQL-invoked procedure reference - invalid authorization specification - invalid catalog name - invalid character set name — cannot drop SQL-session default character set - invalid collation name - invalid condition number - invalid connection name - invalid cursor name - invalid cursor state - invalid grantor - invalid role specification - invalid schema name list specification - invalid target type specification - invalid transaction state — active SQL-transaction - invalid transaction state — branch transaction already active - invalid transaction state — held cursor requires same isolation level - invalid transaction state — inappropriate access mode for branch transaction - invalid transaction state — inappropriate isolation level for branch transaction - invalid transaction state — no active SQL-transaction for branch transaction - invalid transaction state — read-only SQL transaction - invalid transaction state — read-only SQL-transaction - invalid transaction state — schema and data statement mixing not supported - invalid transaction termination - invalid transform group name specification - locator exception — invalid specification - no data — no additional result sets returned - privilege not granted - prohibited statement during trigger execution — modify table modified by data change delta table - prohibited statement encountered during trigger execution - savepoint exception — invalid specification - savepoint exception — too many - syntax error or access rule violation - target table disagrees with cursor specification - transaction rollback with an implementation-defined subclass value - transaction rollback — integrity constraint violation - transaction rollback — serialization failure - transaction rollback — statement completion unknown - triggered action exception - triggered data change violation — modify table modified by data change delta table - with check option violation Daniel -- Daniel Barclay MapR Technologies
