Kbase P24798: ORACLE Rollback err -11041 & ORACLE Commit err -22602 do not exist within ORACLE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/06/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
Oracle DataServer
SYMPTOM(s):
Progress error 1478 and error 1476 returning invalid Oracle error code
SYSTEM ERROR: ORACLE Rollback err -11041 (1478)
SYSTEM ERROR: ORACLE Commit err -22602 (1476)
Error code -11041 does not exist in Oracle
Error code -22602 exist but is not a commit error
CAUSE:
Bug# OE00089138
CAUSE:
Internally, Oracle error code is caculated wrong by the ORACLE DataServer.
FIX:
Upgrade to 10.0A or later.
For the proper return code in version 9, substract (-10000) from the returned error number. In this case, the Oracle error code is -1041 in error (1478) and -12602 in error (1476).
SYSTEM ERROR: ORACLE Rollback err -1041 (1478)
SYSTEM ERROR: ORACLE Commit err -12602 (1476)