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_VIOLATEDconstraintType unique |
ORA-00001 / 1: unique constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType not null |
ORA-01400 / 1400: not null constraint violationORA-01407 / 1407: not null constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType foreign key |
ORA-02291 / 2291: foreign key constraint violationORA-02292 / 2292: foreign key constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType check |
ORA-02290 / 2290: check constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType exclusion |
- | - |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType restrict |
- | - |
| Constraints | SQL_CONSTRAINT_VIOLATED |
constraint cases above | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType too long |
ORA-01401 / 1401: too longORA-12899 / 12899: too long |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType out of range |
ORA-01426 / 1426: out of rangeORA-01438 / 1438: out of rangeORA-01455 / 1455: out of rangeORA-01841 / 1841: out of rangeORA-01847 / 1847: out of rangeORA-01850 / 1850: out of rangeORA-01851 / 1851: out of rangeORA-01852 / 1852: out of rangeORA-01888 / 1888: out of rangeDPI-* (node-oracledb): out of range |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid value |
ORA-01722 / 1722: invalid valueORA-01843 / 1843: invalid valueORA-01882 / 1882: invalid valueNJS-* (node-oracledb): invalid valueDPI-* (node-oracledb): invalid value |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid format |
ORA-01830 / 1830: invalid formatORA-01840 / 1840: invalid formatORA-01858 / 1858: invalid formatORA-01861 / 1861: invalid format |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid encoding |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid json |
ORA-40441 / 40441: invalid jsonORA-40587 / 40587: invalid json |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid xml |
ORA-31011 / 31011: invalid xmlORA-31013 / 31013: invalid xml |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid regular expression |
ORA-12725 / 12725: invalid regular expressionORA-12726 / 12726: invalid regular expressionORA-12727 / 12727: invalid regular expressionORA-12728 / 12728: invalid regular expressionORA-12729 / 12729: invalid regular expressionORA-12730 / 12730: invalid regular expressionORA-12731 / 12731: invalid regular expressionORA-12732 / 12732: invalid regular expressionORA-12733 / 12733: invalid regular expression |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType null not allowed |
- | - |
| Values | SQL_INVALID_VALUEerrorType sequence limit |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType missing |
ORA-01008 / 1008: missing parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType too many |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType wrong count |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid name |
ORA-01006 / 1006: invalid name parameterORA-01036 / 1036: invalid name parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid index |
OCI-22165 (node-oracledb): invalid index parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid type |
NJS-* (node-oracledb): invalid type parameterDPI-* (node-oracledb): invalid type parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid value |
NJS-* (node-oracledb): invalid value parameterDPI-* (node-oracledb): invalid value parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid binding |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType not bindable |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType already bound |
- | - |
| Parameters | SQL_INVALID_PARAMETER |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType database |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType schema |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType table or view |
ORA-00942 / 942: table or view not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType column |
ORA-00904 / 904: column not found when an identifier is extracted from the messageDPI-1022 (node-oracledb): column not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType routine |
ORA-04043 / 4043: routine not found when the message identifies a routine-like objectNJS-169 (node-oracledb): routine not foundNJS-700 (node-oracledb): routine not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType sequence |
ORA-02289 / 2289: sequence not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType collation |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType index |
ORA-01418 / 1418: index not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType trigger |
ORA-04080 / 4080: trigger not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType cursor |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType prepared statement |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType role |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUND |
ORA-04043 / 4043: object not found when the message does not identify a more specific object typeOCI-22303 (node-oracledb): object not found |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType database |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType schema |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType table or view |
ORA-00955 / 955: table or view already exists when the message identifies that object type |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType column |
ORA-01430 / 1430: column already exists |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType routine |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType sequence |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType index |
ORA-01408 / 1408: index already exists |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType trigger |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType cursor |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType 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 typeORA-02264 / 2264: object already exists |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType invalid state |
ORA-04063 / 4063: invalid stateORA-04098 / 4098: invalid stateORA-06575 / 6575: invalid stateNJS-* (node-oracledb): invalid stateDPI-* (node-oracledb): invalid state |
objectStateErrorTypeobjectType when inferredschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType wrong object type |
- | - |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType object in use |
- | - |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType dependent objects still exist |
- | - |
| Statement | SQL_SYNTAX_ERROR |
ORA-00900 / 900: syntax errorORA-00905 / 905: syntax errorORA-00906 / 906: syntax errorORA-00907 / 907: syntax errorORA-00911 / 911: syntax errorORA-00917 / 917: syntax errorORA-00923 / 923: syntax errorORA-00933 / 933: syntax errorORA-00936 / 936: syntax errorORA-01756 / 1756: syntax errorORA-06550 / 6550: syntax error when the message does not contain a PL/SQL diagnostic |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIERidentifierErrorType ambiguous |
ORA-00918 / 918: ambiguous identifier |
identifier when inferredidentifierType when inferredidentifierErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIERidentifierErrorType duplicate |
ORA-00957 / 957: duplicate identifier |
identifier when inferredidentifierType when inferredidentifierErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIER |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType incomplete statement |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid definition |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType type mismatch |
ORA-00932 / 932: type mismatchORA-01790 / 1790: type mismatch |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid statement context |
NJS-019 (node-oracledb): invalid statement contextNJS-095 (node-oracledb): invalid statement contextNJS-157 (node-oracledb): invalid statement contextDPI-1007 (node-oracledb): invalid statement contextDPI-1063 (node-oracledb): invalid statement contextDPI-1087 (node-oracledb): invalid statement context |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid identifier |
ORA-00972 / 972: invalid identifierORA-00904 / 904: invalid identifier when no column identifier can be extracted |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid reference |
ORA-01789 / 1789: invalid reference |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid grouping |
ORA-00934 / 934: invalid groupingORA-00937 / 937: invalid groupingORA-00979 / 979: invalid grouping |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid windowing |
ORA-30483 / 30483: invalid windowingORA-30484 / 30484: invalid windowing |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid recursion |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid locator |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType case not found |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid argument |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENT |
syntax/statement cases above | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_DIVISION_BY_ZERO |
ORA-01476 / 1476: division by zero |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_CARDINALITY_VIOLATION |
ORA-01422 / 1422: cardinality violationORA-01427 / 1427: cardinality violation |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_ROUTINE_ERROR |
ORA-06550 / 6550: routine error when the message contains a PL/SQL diagnosticPLS-: routine error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid state |
ORA-01453 / 1453: invalid stateNJS-170 (node-oracledb): invalid stateTransactionError: invalid state |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType aborted |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType active transaction |
NJS-171 (node-oracledb): active transaction |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType serialization failure |
ORA-08177 / 8177: serialization failure |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType deadlock |
ORA-00060 / 60: deadlock |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType transaction rolled back |
ORA-02050 / 2050: transaction rolled backORA-02055 / 2055: transaction rolled back |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType outcome unknown |
ORA-02054 / 2054: outcome unknown |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid savepoint |
ORA-01086 / 1086: invalid savepoint |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType 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_TIMEOUTtimeoutType connection |
ORA-12170 / 12170: connection timeoutORA-12535 / 12535: connection timeoutNJS-040 (node-oracledb): connection timeoutNJS-510 (node-oracledb): connection timeoutETIMEDOUT (node-oracledb): connection timeoutESOCKETTIMEDOUT (node-oracledb): connection timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType lock |
ORA-00054 / 54: lock timeoutORA-02049 / 2049: lock timeoutORA-04021 / 4021: lock timeoutORA-30006 / 30006: lock timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType statement |
NJS-123 (node-oracledb): statement timeoutDPI-1067 (node-oracledb): statement timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType idle transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType cancelled |
ORA-01013 / 1013: cancelled timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType database file busy |
- | - |
| Connections | SQL_CONNECTION_ERRORerrorType connection lost |
ORA-01012 / 1012: connection lostORA-03113 / 3113: connection lostORA-03114 / 3114: connection lostORA-03135 / 3135: connection lostORA-12537 / 12537: connection lostECONNRESET (node-oracledb): connection lostEPIPE (node-oracledb): connection lost |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType temporarily unavailable |
ORA-01033 / 1033: temporarily unavailableORA-01034 / 1034: temporarily unavailableORA-01089 / 1089: temporarily unavailableORA-12528 / 12528: temporarily unavailableORA-12541 / 12541: temporarily unavailableORA-12543 / 12543: temporarily unavailableNJS-503 (node-oracledb): temporarily unavailableNJS-504 (node-oracledb): temporarily unavailableNJS-511 (node-oracledb): temporarily unavailableECONNREFUSED (node-oracledb): temporarily unavailableEHOSTUNREACH (node-oracledb): temporarily unavailableENETUNREACH (node-oracledb): temporarily unavailable |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType invalid connection configuration |
ORA-12154 / 12154: invalid connection configurationORA-12505 / 12505: invalid connection configurationORA-12514 / 12514: invalid connection configurationORA-12545 / 12545: invalid connection configurationENOTFOUND (node-oracledb): invalid connection configurationEAI_AGAIN (node-oracledb): invalid connection configuration |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType pool error |
NJS-* (node-oracledb): pool errorDPI-1011 (node-oracledb): pool error |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType memory |
ORA-04030 / 4030: memory resource limitORA-04031 / 4031: memory resource limitNJS-024 (node-oracledb): memory resource limitDPI-1001 (node-oracledb): memory resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType disk |
ORA-01653 / 1653: disk resource limitORA-01654 / 1654: disk resource limitORA-01658 / 1658: disk resource limitORA-01688 / 1688: disk resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType temp space |
ORA-01652 / 1652: temp space resource limitORA-30036 / 30036: temp space resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType connections |
ORA-00018 / 18: connections resource limitORA-00020 / 20: connections resource limitORA-12516 / 12516: connections resource limitORA-12519 / 12519: connections resource limitORA-12520 / 12520: connections resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType pool |
NJS-076 (node-oracledb): pool resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType cpu |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType file size |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHED |
ORA-01000 / 1000: resource limit reached |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_AUTHENTICATION_ERROR |
ORA-01017 / 1017: authentication errorORA-28000 / 28000: authentication errorORA-28001 / 28001: authentication error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_AUTHORIZATION_ERROR |
ORA-01045 / 1045: authorization error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_PERMISSION_DENIED |
ORA-01031 / 1031: permission denied |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_READ_ONLY_VIOLATION |
ORA-01456 / 1456: read-only violationORA-16000 / 16000: read-only violation |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType configuration file |
- | - |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType lock file |
- | - |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType runtime parameter |
NJS-069 (node-oracledb): runtime parameter configuration errorDPI-1052 (node-oracledb): runtime parameter configuration errorDPI-1065 (node-oracledb): runtime parameter configuration error |
configurationErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType read |
- | - |
| I/O | SQL_IO_ERRORioErrorType write |
- | - |
| I/O | SQL_IO_ERRORioErrorType fsync |
- | - |
| I/O | SQL_IO_ERRORioErrorType truncate |
- | - |
| I/O | SQL_IO_ERRORioErrorType file stat |
- | - |
| I/O | SQL_IO_ERRORioErrorType lock |
- | - |
| I/O | SQL_IO_ERRORioErrorType unlock |
- | - |
| I/O | SQL_IO_ERRORioErrorType delete |
- | - |
| I/O | SQL_IO_ERRORioErrorType file not found |
- | - |
| I/O | SQL_IO_ERRORioErrorType access |
- | - |
| I/O | SQL_IO_ERRORioErrorType shared memory |
- | - |
| I/O | SQL_IO_ERRORioErrorType seek |
- | - |
| I/O | SQL_IO_ERRORioErrorType mmap |
- | - |
| I/O | SQL_IO_ERRORioErrorType path |
- | - |
| I/O | SQL_IO_ERRORioErrorType atomic write |
- | - |
| I/O | SQL_IO_ERRORioErrorType close |
- | - |
| I/O | SQL_IO_ERRORioErrorType reserved extension |
- | - |
| I/O | SQL_IO_ERRORioErrorType unknown |
DPI-1075 (node-oracledb): unknown I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| External | SQL_EXTERNAL_DATA_SOURCE_ERROR |
ORA-02063 / 2063: external data source errorORA-02068 / 2068: external data source errorORA-28500 / 28500: external data source error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Features | SQL_FEATURE_NOT_SUPPORTED |
ORA-03001 / 3001: feature not supportedORA-00439 / 439: feature not supportedORA-22816 / 22816: feature not supportedORA-32034 / 32034: feature not supportedOCI-22164 (node-oracledb): feature not supported |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType database file |
ORA-01578 / 1578: database file corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType index |
ORA-08102 / 8102: index corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType sequence |
- | - |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType virtual table |
- | - |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType filesystem |
- | - |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType checksum |
- | - |
| Internal | SQL_INTERNAL_ERRORerrorType engine internal |
ORA-00600 / 600: engine internalORA-00603 / 603: engine internalORA-01041 / 1041: engine internalORA-07445 / 7445: engine internal |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Internal | SQL_INTERNAL_ERRORerrorType api misuse |
NJS-* (node-oracledb): api misuseDPI-* (node-oracledb): api misuse |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Fallback | SQL_UNKNOWN |
ORA-20000 / 20000: unknown SQL errorORA-20999 / 20999: unknown SQL error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |