Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.


Action

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