DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

lock/deadlock detection

423535Jun 16 2004 — edited Jun 17 2004

Hi,

would sbdy advice me how to detect lock/deadlock ?
We are using OCI -- wrapped by C++ classes -- to access database (9.2). The issue is that the OCIStmtExecute() call gets blocked when the particular row is locked by active transaction in other session (other client).

What I'd like is making the OCIStmtExecute() to return immediately with error in such situations, but don't know how. Any help appreciated :).

Thanks in advance
/Libor

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2004

Added on Jun 16 2004

#oracle-call-interface-oci

7 comments

814 views