> 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
Juan Carlos Perez Vazquez Cray2@mail.com