# eXtremeDB SQL Return Codes

> The following SQL return codes indicate SQL-specific runtime or error conditions that might be returned by the eXtremeDB runtime while processing SQL statements:

> Mnemonic Constant Name
> Value
> Meaning
> SQL_OK
> 0
> Successful SQL execution
> NO_MORE_ELEMENTS
> 1
> End of result set reached
> INVALID_TYPE_CAST
> 2
> Attempt to cast to an invalid SQL type
> COMPILE_ERROR
> 3
> Error compiling SQL statement
> NOT_SINGLE_VALUE
> 4
> Result set with more than one row returned
> INVALID_OPERATION
> 5
> Not a valid SQL operation
> INDEX_OUT_OF_BOUNDS
> 6
> Attempt to access outside of array bounds
> NOT_ENOUGH_MEMORY
> 7
> Out of memory executing SQL statement
> NOT_UNIQUE
> 8
> Attempt to insert a record with duplicate identifier value
> NOT_PREPARED
> 9
> Attempt to execute a pre-compiled statement that was not prepared
> RUNTIME_ERROR
> 10
> Unknown SQL runtime error
> COMMUNICATION_ERROR
> 11
> Unknown communication error
> UPGRADE_NOT_POSSIBLE
> 12
> Unable to upgrade transaction to `READ_WRITE`
> SQL_CONFLICT
> 13
> SQL conflict while updating a record
> SQL_NULL_REFERENCE
> 14
> Attempt to dereference a NULL reference
> SQL_INVALID_STATE
> 15
> Invalid executor state
> SQL_INVALID_OPERAND
> 16
> Invalid function operand
> SQL_NULL_VALUE
> 17
> A null value encountered in a context not accepting null values
> SQL_BAD_CSV_FORMAT
> 18
> Wrong format in CSV file
> SQL_SYSTEM_ERROR
> 19
> Internal SQL engine error

> Related Topics