We have some problems with explicit locking. We are building an
MS-Access client application storing it's data on an ORACLE-server.
When one user tries to update or delete a specific record on a table,
and this record is currently in use by another user, one has to
wait for this lock to be released. Now I can find in an ORACLE guide
the following: "If the wait for a row lock is excessive, users
might want to cancel the lock operation and retry at a later time;
you might prefer to code such logic into applications."
Yes indeed, I would like to do this, I only don't now how. How can I
cancel a lock operation which is already waiting??? My application
just hangs and doesn't proceed until the lock is released ????
Can anybody help me with this, please !!
Esther Salk
--
