Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
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?
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
![]() |
![]() |