# SQL Return Codes

The framework generally returns the database-specific return codes from SQL execution. However, the framework returns Oracle Utilities-specific return codes for commonly used SQL execution result messages. These Oracle Utilities-specific return codes are the same regardless of the database. This allows programs to be portable across different databases.

The following lists the return codes:

SQL Execution Result | Return Code
--- | ---
OK | 0
* Unnumbered SQL Error | 999999990
Warning | 999999991
End / no (more) row retrieved | 999999992
Duplicate / unique index violation | 999999993
More / multiple rows retrieved in single-row select | 999999994
Deadlock | 999999995
No connection | 999999996
* Application Error | 999999997
* Hibernate Error | 999999998
* Programmatic Error | 999999999

Note: The SQL return codes marked with an asterisk (*) are for errors peripheral to the actual execution of the SQL and do not have equivalent database return codes.
Parent topic: Public API