Skip to content

Oracle Error Mapping

This page lists how native Oracle database or driver errors are represented as TsSqlErrorReason values. The table uses the same row catalog and row order as the other native database pages, so a - means this semantic case is not currently mapped for Oracle.

Database error shows the values exposed through databaseErrorCode and databaseErrorNumber when both are available. Connector-only signals include the connector inline. SQL_UNKNOWN is intentionally the last row.

Exact mapper-known codes are listed individually. Broad class, range, or message-pattern fallbacks are kept when the mapper intentionally handles an open-ended family of errors; if the same native code appears in more than one row, the driver message determines the final mapped reason.

Category Reason Database error Filled fields
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
unique
ORA-00001 / 1: unique constraint violation constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
not null
ORA-01400 / 1400: not null constraint violation
ORA-01407 / 1407: not null constraint violation
constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
foreign key
ORA-02291 / 2291: foreign key constraint violation
ORA-02292 / 2292: foreign key constraint violation
constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
check
ORA-02290 / 2290: check constraint violation constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
exclusion
- -
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
restrict
- -
Constraints SQL_CONSTRAINT_VIOLATED constraint cases above databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
too long
ORA-01401 / 1401: too long
ORA-12899 / 12899: too long
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
out of range
ORA-01426 / 1426: out of range
ORA-01438 / 1438: out of range
ORA-01455 / 1455: out of range
ORA-01841 / 1841: out of range
ORA-01847 / 1847: out of range
ORA-01850 / 1850: out of range
ORA-01851 / 1851: out of range
ORA-01852 / 1852: out of range
ORA-01888 / 1888: out of range
DPI-* (node-oracledb): out of range
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid value
ORA-01722 / 1722: invalid value
ORA-01843 / 1843: invalid value
ORA-01882 / 1882: invalid value
NJS-* (node-oracledb): invalid value
DPI-* (node-oracledb): invalid value
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid format
ORA-01830 / 1830: invalid format
ORA-01840 / 1840: invalid format
ORA-01858 / 1858: invalid format
ORA-01861 / 1861: invalid format
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid encoding
- -
Values SQL_INVALID_VALUE
errorType
invalid json
ORA-40441 / 40441: invalid json
ORA-40587 / 40587: invalid json
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid xml
ORA-31011 / 31011: invalid xml
ORA-31013 / 31013: invalid xml
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid regular expression
ORA-12725 / 12725: invalid regular expression
ORA-12726 / 12726: invalid regular expression
ORA-12727 / 12727: invalid regular expression
ORA-12728 / 12728: invalid regular expression
ORA-12729 / 12729: invalid regular expression
ORA-12730 / 12730: invalid regular expression
ORA-12731 / 12731: invalid regular expression
ORA-12732 / 12732: invalid regular expression
ORA-12733 / 12733: invalid regular expression
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
null not allowed
- -
Values SQL_INVALID_VALUE
errorType
sequence limit
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
missing
ORA-01008 / 1008: missing parameter parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
too many
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
wrong count
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid name
ORA-01006 / 1006: invalid name parameter
ORA-01036 / 1036: invalid name parameter
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid index
OCI-22165 (node-oracledb): invalid index parameter parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid type
NJS-* (node-oracledb): invalid type parameter
DPI-* (node-oracledb): invalid type parameter
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid value
NJS-* (node-oracledb): invalid value parameter
DPI-* (node-oracledb): invalid value parameter
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid binding
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
not bindable
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
already bound
- -
Parameters SQL_INVALID_PARAMETER - -
Object not found SQL_OBJECT_NOT_FOUND
objectType
database
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
schema
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
table or view
ORA-00942 / 942: table or view not found objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
column
ORA-00904 / 904: column not found when an identifier is extracted from the message
DPI-1022 (node-oracledb): column not found
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
routine
ORA-04043 / 4043: routine not found when the message identifies a routine-like object
NJS-169 (node-oracledb): routine not found
NJS-700 (node-oracledb): routine not found
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
sequence
ORA-02289 / 2289: sequence not found objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
collation
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
index
ORA-01418 / 1418: index not found objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
trigger
ORA-04080 / 4080: trigger not found objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
cursor
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
prepared statement
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
role
- -
Object not found SQL_OBJECT_NOT_FOUND ORA-04043 / 4043: object not found when the message does not identify a more specific object type
OCI-22303 (node-oracledb): object not found
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
database
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
schema
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
table or view
ORA-00955 / 955: table or view already exists when the message identifies that object type objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
column
ORA-01430 / 1430: column already exists objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
routine
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
sequence
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
index
ORA-01408 / 1408: index already exists objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
trigger
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
cursor
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
prepared statement
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS ORA-00955 / 955: object already exists when the message does not identify a more specific object type
ORA-02264 / 2264: object already exists
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
invalid state
ORA-04063 / 4063: invalid state
ORA-04098 / 4098: invalid state
ORA-06575 / 6575: invalid state
NJS-* (node-oracledb): invalid state
DPI-* (node-oracledb): invalid state
objectStateErrorType
objectType when inferred
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
wrong object type
- -
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
object in use
- -
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
dependent objects still exist
- -
Statement SQL_SYNTAX_ERROR ORA-00900 / 900: syntax error
ORA-00905 / 905: syntax error
ORA-00906 / 906: syntax error
ORA-00907 / 907: syntax error
ORA-00911 / 911: syntax error
ORA-00917 / 917: syntax error
ORA-00923 / 923: syntax error
ORA-00933 / 933: syntax error
ORA-00936 / 936: syntax error
ORA-01756 / 1756: syntax error
ORA-06550 / 6550: syntax error when the message does not contain a PL/SQL diagnostic
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_AMBIGUOUS_IDENTIFIER
identifierErrorType
ambiguous
ORA-00918 / 918: ambiguous identifier identifier when inferred
identifierType when inferred
identifierErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_AMBIGUOUS_IDENTIFIER
identifierErrorType
duplicate
ORA-00957 / 957: duplicate identifier identifier when inferred
identifierType when inferred
identifierErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_AMBIGUOUS_IDENTIFIER - -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
incomplete statement
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid definition
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
type mismatch
ORA-00932 / 932: type mismatch
ORA-01790 / 1790: type mismatch
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid statement context
NJS-019 (node-oracledb): invalid statement context
NJS-095 (node-oracledb): invalid statement context
NJS-157 (node-oracledb): invalid statement context
DPI-1007 (node-oracledb): invalid statement context
DPI-1063 (node-oracledb): invalid statement context
DPI-1087 (node-oracledb): invalid statement context
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid identifier
ORA-00972 / 972: invalid identifier
ORA-00904 / 904: invalid identifier when no column identifier can be extracted
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid reference
ORA-01789 / 1789: invalid reference statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid grouping
ORA-00934 / 934: invalid grouping
ORA-00937 / 937: invalid grouping
ORA-00979 / 979: invalid grouping
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid windowing
ORA-30483 / 30483: invalid windowing
ORA-30484 / 30484: invalid windowing
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid recursion
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid locator
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
case not found
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid argument
- -
Statement SQL_INVALID_SQL_STATEMENT syntax/statement cases above databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Execution SQL_DIVISION_BY_ZERO ORA-01476 / 1476: division by zero databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Execution SQL_CARDINALITY_VIOLATION ORA-01422 / 1422: cardinality violation
ORA-01427 / 1427: cardinality violation
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Execution SQL_ROUTINE_ERROR ORA-06550 / 6550: routine error when the message contains a PL/SQL diagnostic
PLS-: routine error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
invalid state
ORA-01453 / 1453: invalid state
NJS-170 (node-oracledb): invalid state
TransactionError: invalid state
transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
aborted
- -
Transactions TRANSACTION_ERROR
transactionErrorType
active transaction
NJS-171 (node-oracledb): active transaction transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
serialization failure
ORA-08177 / 8177: serialization failure transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
deadlock
ORA-00060 / 60: deadlock transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
transaction rolled back
ORA-02050 / 2050: transaction rolled back
ORA-02055 / 2055: transaction rolled back
transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
outcome unknown
ORA-02054 / 2054: outcome unknown transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
invalid savepoint
ORA-01086 / 1086: invalid savepoint transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
unsupported operation
- -
Transactions NOT_IN_TRANSACTION NJS-172 (node-oracledb): not in transaction driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields
Transactions NESTED_TRANSACTION_NOT_SUPPORTED raised directly by ts-sql-query nested transaction checks driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields
Transactions FORBIDDEN_CONCURRENT_USAGE raised directly by query-runner concurrent usage checks driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields
Transactions TRANSACTION_LEVEL_NOT_SUPPORTED raised directly by query runners that reject the isolation level transactionLevel
Transactions TRANSACTION_ACCESS_MODE_NOT_SUPPORTED raised directly by query runners that reject the transaction access mode accessMode
Timeouts SQL_TIMEOUT
timeoutType
connection
ORA-12170 / 12170: connection timeout
ORA-12535 / 12535: connection timeout
NJS-040 (node-oracledb): connection timeout
NJS-510 (node-oracledb): connection timeout
ETIMEDOUT (node-oracledb): connection timeout
ESOCKETTIMEDOUT (node-oracledb): connection timeout
timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
lock
ORA-00054 / 54: lock timeout
ORA-02049 / 2049: lock timeout
ORA-04021 / 4021: lock timeout
ORA-30006 / 30006: lock timeout
timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
statement
NJS-123 (node-oracledb): statement timeout
DPI-1067 (node-oracledb): statement timeout
timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
transaction
- -
Timeouts SQL_TIMEOUT
timeoutType
idle transaction
- -
Timeouts SQL_TIMEOUT
timeoutType
cancelled
ORA-01013 / 1013: cancelled timeout timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
database file busy
- -
Connections SQL_CONNECTION_ERROR
errorType
connection lost
ORA-01012 / 1012: connection lost
ORA-03113 / 3113: connection lost
ORA-03114 / 3114: connection lost
ORA-03135 / 3135: connection lost
ORA-12537 / 12537: connection lost
ECONNRESET (node-oracledb): connection lost
EPIPE (node-oracledb): connection lost
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Connections SQL_CONNECTION_ERROR
errorType
temporarily unavailable
ORA-01033 / 1033: temporarily unavailable
ORA-01034 / 1034: temporarily unavailable
ORA-01089 / 1089: temporarily unavailable
ORA-12528 / 12528: temporarily unavailable
ORA-12541 / 12541: temporarily unavailable
ORA-12543 / 12543: temporarily unavailable
NJS-503 (node-oracledb): temporarily unavailable
NJS-504 (node-oracledb): temporarily unavailable
NJS-511 (node-oracledb): temporarily unavailable
ECONNREFUSED (node-oracledb): temporarily unavailable
EHOSTUNREACH (node-oracledb): temporarily unavailable
ENETUNREACH (node-oracledb): temporarily unavailable
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Connections SQL_CONNECTION_ERROR
errorType
invalid connection configuration
ORA-12154 / 12154: invalid connection configuration
ORA-12505 / 12505: invalid connection configuration
ORA-12514 / 12514: invalid connection configuration
ORA-12545 / 12545: invalid connection configuration
ENOTFOUND (node-oracledb): invalid connection configuration
EAI_AGAIN (node-oracledb): invalid connection configuration
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Connections SQL_CONNECTION_ERROR
errorType
pool error
NJS-* (node-oracledb): pool error
DPI-1011 (node-oracledb): pool error
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
memory
ORA-04030 / 4030: memory resource limit
ORA-04031 / 4031: memory resource limit
NJS-024 (node-oracledb): memory resource limit
DPI-1001 (node-oracledb): memory resource limit
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
disk
ORA-01653 / 1653: disk resource limit
ORA-01654 / 1654: disk resource limit
ORA-01658 / 1658: disk resource limit
ORA-01688 / 1688: disk resource limit
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
temp space
ORA-01652 / 1652: temp space resource limit
ORA-30036 / 30036: temp space resource limit
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
connections
ORA-00018 / 18: connections resource limit
ORA-00020 / 20: connections resource limit
ORA-12516 / 12516: connections resource limit
ORA-12519 / 12519: connections resource limit
ORA-12520 / 12520: connections resource limit
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
pool
NJS-076 (node-oracledb): pool resource limit resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
cpu
- -
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
file size
- -
Resources SQL_RESOURCE_LIMIT_REACHED ORA-01000 / 1000: resource limit reached resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_AUTHENTICATION_ERROR ORA-01017 / 1017: authentication error
ORA-28000 / 28000: authentication error
ORA-28001 / 28001: authentication error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_AUTHORIZATION_ERROR ORA-01045 / 1045: authorization error databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_PERMISSION_DENIED ORA-01031 / 1031: permission denied databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_READ_ONLY_VIOLATION ORA-01456 / 1456: read-only violation
ORA-16000 / 16000: read-only violation
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Configuration SQL_CONFIGURATION_ERROR
configurationErrorType
configuration file
- -
Configuration SQL_CONFIGURATION_ERROR
configurationErrorType
lock file
- -
Configuration SQL_CONFIGURATION_ERROR
configurationErrorType
runtime parameter
NJS-069 (node-oracledb): runtime parameter configuration error
DPI-1052 (node-oracledb): runtime parameter configuration error
DPI-1065 (node-oracledb): runtime parameter configuration error
configurationErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
read
- -
I/O SQL_IO_ERROR
ioErrorType
write
- -
I/O SQL_IO_ERROR
ioErrorType
fsync
- -
I/O SQL_IO_ERROR
ioErrorType
truncate
- -
I/O SQL_IO_ERROR
ioErrorType
file stat
- -
I/O SQL_IO_ERROR
ioErrorType
lock
- -
I/O SQL_IO_ERROR
ioErrorType
unlock
- -
I/O SQL_IO_ERROR
ioErrorType
delete
- -
I/O SQL_IO_ERROR
ioErrorType
file not found
- -
I/O SQL_IO_ERROR
ioErrorType
access
- -
I/O SQL_IO_ERROR
ioErrorType
shared memory
- -
I/O SQL_IO_ERROR
ioErrorType
seek
- -
I/O SQL_IO_ERROR
ioErrorType
mmap
- -
I/O SQL_IO_ERROR
ioErrorType
path
- -
I/O SQL_IO_ERROR
ioErrorType
atomic write
- -
I/O SQL_IO_ERROR
ioErrorType
close
- -
I/O SQL_IO_ERROR
ioErrorType
reserved extension
- -
I/O SQL_IO_ERROR
ioErrorType
unknown
DPI-1075 (node-oracledb): unknown I/O error ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
External SQL_EXTERNAL_DATA_SOURCE_ERROR ORA-02063 / 2063: external data source error
ORA-02068 / 2068: external data source error
ORA-28500 / 28500: external data source error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Features SQL_FEATURE_NOT_SUPPORTED ORA-03001 / 3001: feature not supported
ORA-00439 / 439: feature not supported
ORA-22816 / 22816: feature not supported
ORA-32034 / 32034: feature not supported
OCI-22164 (node-oracledb): feature not supported
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Corruption SQL_DATABASE_CORRUPTED
corruptionType
database file
ORA-01578 / 1578: database file corruption corruptionType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Corruption SQL_DATABASE_CORRUPTED
corruptionType
index
ORA-08102 / 8102: index corruption corruptionType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Corruption SQL_DATABASE_CORRUPTED
corruptionType
sequence
- -
Corruption SQL_DATABASE_CORRUPTED
corruptionType
virtual table
- -
Corruption SQL_DATABASE_CORRUPTED
corruptionType
filesystem
- -
Corruption SQL_DATABASE_CORRUPTED
corruptionType
checksum
- -
Internal SQL_INTERNAL_ERROR
errorType
engine internal
ORA-00600 / 600: engine internal
ORA-00603 / 603: engine internal
ORA-01041 / 1041: engine internal
ORA-07445 / 7445: engine internal
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Internal SQL_INTERNAL_ERROR
errorType
api misuse
NJS-* (node-oracledb): api misuse
DPI-* (node-oracledb): api misuse
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Fallback SQL_UNKNOWN ORA-20000 / 20000: unknown SQL error
ORA-20999 / 20999: unknown SQL error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage