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.