knowing if table is lock with non dba privlges

From: andrew phuong <caop_at_infosci.com.au>
Date: Fri, 10 Nov 2000 10:53:56 +1100
Message-ID: <ZOGO5.12$Li.3752@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 Thu Nov 09 2000 - 17:53:56 CST