Re: How to find out if a record is locked?
From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/10/15
Message-ID: <32648ffb.3348612_at_n5.gbso.net>#1/1
Date: 1996/10/15
Message-ID: <32648ffb.3348612_at_n5.gbso.net>#1/1
tim_at_van.oz.au (Tim Nguyen) wrote:
>Hi world,
>When I insert/update a record in the DB server from Forms, is there
>any way the server can tell me that the record is currently locked?
>Thanks,
>Tim.
Can't say I've done it from Forms, but you could try doing a 'SELECT...FOR UPDATE NOWAIT' prior to updating. If you get an ORA-0054 error, it's locked.
-- Chuck Hamilton chuckh_at_dvol.com This message delivered by electronic sled dogs. WOOF!Received on Tue Oct 15 1996 - 00:00:00 CEST