Re: knowing if table is lock with non dba privlges

From: <steveee_ca_at_my-deja.com>
Date: Fri, 10 Nov 2000 14:45:50 GMT
Message-ID: <8uh1mr$ja$1@nnrp1.deja.com>

Hi,
I'd just add to John's suggestion about NOWAIT.. You can trap for the error that's generated when the NOWAIT statement encounters a lock..off the top of my head I can recall the error number but it's available in lots of reference sources

Hth

In article <YDRO5.23823$Ze6.3106833_at_typhoon.tampabay.rr.com>, "John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote:
> Look at using the NOWAIT option when you update.
> andrew phuong <caop_at_infosci.com.au> wrote in message
> news:ZOGO5.12$Li.3752_at_vic.nntp.telstra.net...
> > Hi All,
> >
> > With PL/SQL, is it possible to write a function such
> > that if the table is in a locked state, then return an error value
or
> > something
> > so that the script doesn't halt there waiting for the table to be
unlock.
> >
> > I know that there are tables that contains data of which tables are
> > locked but these require higher privileges which I do not want to
> > grant to the user.
> >
> > I've been searching through the text but to no avail. Any
> > gurus who can help me on this??
> >
> > Thanks a million.
> >
> > Andrew
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 10 2000 - 08:45:50 CST