RE: Row Level Locking Problem

> Well, this is how it is supposed to work.  "select for update" only
> works within a transaction and holds the lock until the transaction
> is complete.
>
> What exactly is it that you're trying to do?

Let us suppose that we have 2 transactions, and attempt to block the
same row in the two transactions. One of them will wait until in the other
it is commited or rollbacked.

Oracle has "select for update nowait",  it does that instead of waiting
the conclusion of the other  transaction, gives back an error to us saying
that the row already has been blocked.

I am looking for something similar to this, or in its defect, knowledge
if a row has been blocked, to avoid this waits, or information to make the
parameter 'nowait' to realize this operation

Juan Carlos Perez Vazquez
Cray2@mail.com


______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup