OCL error codes (reference) v15

The following table lists the error code mappings defined by the OCL Connector. When the database server reports an error code or condition (shown in the first or second column), the OCL converts the value to the compatible value displayed in the third column.

Error codeCondition nameOracle error code
42601syntax_errorORA-16945
42P01undefined_tableORA-00942
02000no_dataORA-01403
08000connection_exceptionORA-12545
08003connection_does_not_existORA-12545
08006connection_failureORA-12545
08001sqlclient_unable_to_establish_sqlconnectionORA-12545
08004sqlserver_rejected_establishment_of_sqlconnectionORA-12545
25000invalid_transaction_stateORA-01453
08007transaction_resolution_unknownORA-01453
0A000feature_not_supportedORA-03001
22012division_by_zeroORA-01476
2200Bescape_character_conflictORA-01424
22019invalid_escape_characterORA-00911
2200Dinvalid_escape_octetORA-01424
22025invalid_escape_sequenceORA-01424
22P06nonstandard_use_of_escape_characterORA-01424
2200Cinvalid_use_of_escape_characterORA-01424
22004null_value_not_allowedORA-01400
23000integrity_constraint_violationORA-00001
23505unique_violationORA-00001
40P01t_r_deadlock_detectedORA-00060
42701duplicate_columnORA-01430
53000insufficient_resourcesORA-01659
53100disk_fullORA-01659
53200out_of_memoryORA-82100
42P07duplicate_tableORA-00955
21000cardinality_violationORA-01427
22003numeric_value_out_of_rangeORA-01426
22P02invalid_text_representationORA-01858
28000invalid_authorization_specificationORA-01017
28P01invalid_passwordORA-01017
2200Fzero_length_character_stringORA-01425
42704undefined_objectORA-01418
2BP01dependent_objects_still_existORA-02429
22027trim_errorORA-30001
22001string_data_right_truncationORA-01401
22002null_value_no_indicator_parameterORA-01405
22008datetime_field_overflowORA-01800
44000with_check_option_violationORA-01402
01007warning_privilege_not_grantedORA-00000
01006warning_privilege_not_revokedORA-00000
02001no_additional_dynamic_result_sets_returnedORA-00000
03000sql_statement_not_yet_completeORA-00000
08P01protocol_violationORA-00000
23001restrict_violationORA-00000
23502not_null_violationORA-00000
23505foreign_key_violationORA-00000
23514check_violationORA-00000
24000invalid_cursor_stateORA-01001
26000invalid_sql_statement_nameORA-00000
42830invalid_foreign_keyORA-00000
55006object_in_useORA-00000
55P03lock_not_availableORA-00054
72000snapshot_too_oldORA-01555

For more information about Postgres error codes, see the PostgreSQL core documentation.