OCL Error Codes – Reference

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 Code Condition Name Oracle Error Code
42601 syntax_error ORA-16945
42P01 undefined_table ORA-00942
02000 no_data ORA-01403
08000 connection_exception ORA-12545
08003 connection_does_not_exist ORA-12545
08006 connection_failure ORA-12545
08001 sqlclient_unable_to_establish_sqlconnection ORA-12545
08004 sqlserver_rejected_establishment_of_sqlconnection ORA-12545
25000 invalid_transaction_state ORA-01453
08007 transaction_resolution_unknown ORA-01453
0A000 feature_not_supported ORA-03001
22012 division_by_zero ORA-01476
2200B escape_character_conflict ORA-01424
22019 invalid_escape_character ORA-00911
2200D invalid_escape_octet ORA-01424
22025 invalid_escape_sequence ORA-01424
22P06 nonstandard_use_of_escape_character ORA-01424
2200C invalid_use_of_escape_character ORA-01424
22004 null_value_not_allowed ORA-01400
23000 integrity_constraint_violation ORA-00001
23505 unique_violation ORA-00001
40P01 t_r_deadlock_detected ORA-00060
42701 duplicate_column ORA-01430
53000 insufficient_resources ORA-01659
53100 disk_full ORA-01659
53200 out_of_memory ORA-82100
42P07 duplicate_table ORA-00955
21000 cardinality_violation ORA-01427
22003 numeric_value_out_of_range ORA-01426
22P02 invalid_text_representation ORA-01858
28000 invalid_authorization_specification ORA-01017
28P01 invalid_password ORA-01017
2200F zero_length_character_string ORA-01425
42704 undefined_object ORA-01418
2BP01 dependent_objects_still_exist ORA-02429
22027 trim_error ORA-30001
22001 string_data_right_truncation ORA-01401
22002 null_value_no_indicator_parameter ORA-01405
22008 datetime_field_overflow ORA-01800
44000 with_check_option_violation ORA-01402
01007 warning_privilege_not_granted ORA-00000
01006 warning_privilege_not_revoked ORA-00000
02001 no_additional_dynamic_result_sets_returned ORA-00000
03000 sql_statement_not_yet_complete ORA-00000
08P01 protocol_violation ORA-00000
23001 restrict_violation ORA-00000
23502 not_null_violation ORA-00000
23505 foreign_key_violation ORA-00000
23514 check_violation ORA-00000
24000 invalid_cursor_state ORA-01001
26000 invalid_sql_statement_name ORA-00000
42830 invalid_foreign_key ORA-00000
55006 object_in_use ORA-00000
55P03 lock_not_available ORA-00054
72000 snapshot_too_old ORA-01555

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