ORA-24775: cannot prepare or commit transaction with non-zero lock value

You are here: Home // Oracle 11g // ORA-24775: cannot prepare or commit transaction with non-zero lock value

Cause: An attempt was made to detach the transaction with a non-zero lock value. See the solution below.

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

Database version: Oracle 11g Release 2 (11.2)