Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: knowing if table is lock with non dba privlges
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
>
>
>
Received on Fri Nov 10 2000 - 06:13:44 CST