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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00146: Internal-- Retry data request withing pump.

1 Answers  


PLS-01407: One of the identifiers CHAR, CHARACTER, or INTEGER has been redefined by the programmer

1 Answers  


ORA-19575: expected string blocks in file string, found string

1 Answers  


ORA-12841: Cannot alter the session parallel DML state within a transaction

1 Answers  


ORA-02285: duplicate START WITH specifications

1 Answers  






RMAN-06186: PL/SQL package string.string version string in string database is too old

1 Answers  


SQL*Loader-00104: Invalid bad file name on command line

1 Answers  


ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

1 Answers  


ORA-06922: CMX: bad write length

1 Answers  


ORA-31445: invalid lock handle while acquiring lock on string

1 Answers  


NNL-00301: Server shutting down

1 Answers  


ORA-29810: inadequate operator privileges

1 Answers  


Categories