From: chuckh@dvol.com (Chuck Hamilton)
Subject: Re: How to find out if a record is locked?
Date: 1996/10/15
Message-ID: <32648ffb.3348612@n5.gbso.net>#1/1
references: <1996Oct14.233826.23033@van.oz.au>
content-type: text/plain; charset=us-ascii
organization: Do I look organized to you?
mime-version: 1.0
newsgroups: comp.databases.oracle



tim@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@dvol.com

This message delivered by electronic sled dogs. WOOF!