Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to find out if a user is locking a particular record from a Forms 5 environment?

Re: Is it possible to find out if a user is locking a particular record from a Forms 5 environment?

From: <tjmxyz_at_my-deja.com>
Date: Fri, 06 Aug 1999 11:49:50 GMT
Message-ID: <7oei4s$1cv$1@nnrp1.deja.com>


the way I know how to do it is.
Select blah_balh blah where blah for update;

If this fails the record is locked..

Simply trap any errors that occur when running your Select for update statement.

In article <37AAB732.F0C_at_capgemini.co.uk>,   claire.moore_at_capgemini.co.uk wrote:
> Hi,
>
> I am trying to pre-emp 2 users trying to update the same record at
once.
> (The users don't like the Forms 5 inbuilt message that appears when
> oracle cannot lock the record for update!!) and the only way that I
can
> achieve this with minimum fuss is I think to check to see if a
> particular record is being locked by another user prior to allowing a
> user into that record.
>
> I know you can run a query to find out if a table is locked, but can
you
> narrow it down to specific record(s).
>
> Alternatively, does anyone know how to trap the inbuilt error message
> that you get when editing a record that is locked by someone else -
It
> has no error number. Or is there any other way to achieve my goal.
>
> Thanks in advance
>
> Claire
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 06 1999 - 06:49:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US