Re: locking

From: Frank <franjoe_at_frisurf.no>
Date: Tue, 27 Mar 2001 20:17:49 +0200
Message-ID: <kP4w6.165$R6.3355@news1.oke.nextra.no>

Hi!

If your worry is that you will "hang" on the update while some other session has uncommitted changes,
have a look at the NOWAIT option to UPDATE/INSERT/DELETE. That option will give you
a exception instead of waiting for the other transaction. This is not a solution if you only whish to check if someone have a lock, and you don't want to
perform any update yourself because this one _will_ take a lock.

Frank.

Norbert <usun_to.norbert_at_exbud.com.pl> wrote in message news:99q2iu$7gj$1_at_news.tpi.pl...
> greets,
>
> How can I tell if the given record is locked without attempting to lock it
?
>
> Norbert
>
>
Received on Tue Mar 27 2001 - 12:17:49 CST