About concurent transaction, and reaction for lock

From: Alexander Kot <Alexander.Kot_at_atlas.kiev.ua>
Date: Thu, 7 Nov 2002 20:09:41 +0200
Message-ID: <30aeqa.6n4.ln@mail.atlas.kiev.ua>

Hello, All!

Oracle 8.1.7

When I update the same row from 2 different sessions, the second session wait while 1st finish transaction, and then update this row too.

It seems to me that it have to be such mode, when 2d session instead of waiting has an exception (Such behavior has Informix foer example).

I understand that, exists select .. for update no wait. But if I have triggers on this table, and it can concurrent for other row in other table, how can I prepare all needed resources for update?

It would be perfect situation to have an exception, and cancel execution of 2d session.

So the question: is such mode exists?

If not how to emulate such behavior in case of existing trigger, and I have no access to its declaration?

With best regards, Alexander Kot. E-mail: Alexander.Kot_at_atlas.kiev.ua Received on Thu Nov 07 2002 - 12:09:41 CST