Re: Exclusive (non-reentrant) Stored Procedure

From: Stefan Jahnke <q5665841_at_bonsai.fernuni-hagen.de>
Date: Wed, 27 Dec 2000 17:37:57 +0100
Message-ID: <3A4A1AE5.97EA81B5@bonsai.fernuni-hagen.de>

dejaschirf_at_my-deja.com wrote:
>
> I need to create a stored procedure that is, in effect, not reentrant.
> What I?d like to have happen is for any calls to the stored procedure
> which occur while it is already running to immediately return as if
> they had run successfully. I?ve looked for a semaphore mechanism in
> Oracle but have had no luck finding a way to create a resource lock
> that will unlock automatically on unexpected termination.
>
> Can anyone help me with this?
>
> Paul Schirf
> Frustrated Oracle Developer
>
> Sent via Deja.com
> http://www.deja.com/

hi,

I don't know if speed is essential, but you could also write an external procedure that utilizes operating system semaphores instead of writing a lock flag to a table.
I don't really know what's faster, it's just an idea. But I guess the semaphores will do, since you don't need additional I/O. On Unix, have your admin set the OS semaphore kernel parameters up in case you use them intensively.

ciao
Stefan Received on Wed Dec 27 2000 - 10:37:57 CST