Re: "NOWAIT"

From: van der Linden <van.der.Linden_at_wxs.nl>
Date: Fri, 8 May 1998 19:54:59 +0200
Message-ID: <6ivh2e$f3n111@reader3.wxs.nl>

The only possibility I see to set up your own locks using the dbms_lock package.
With this you can define your own (for instance exclusive) lock (with the name of the table or the primairy key or any level you want to lock).

Every insert procedure must first set the lock . If this is successfull you can be sure
the insert won't be stopped by an insert from an other session.

Hope this is a possibility
C.G. van der Linden

P.S. you can set the lock to unlock on committime. Received on Fri May 08 1998 - 12:54:59 CDT