Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-24775 – cannot prepare or commit transaction with non-zero lock value

Oracle Database Error Code ORA-24775 Description :

cannot prepare or commit transaction with non-zero lock value

Error Cause:

An attempt was made to detach the transaction with a non-zero lock value.

How to Solve :

Detach the transaction with lock value set to zero and then try to prepare or commit the transaction.