Re: PL/SQL Help

From: Steve Blomeley <steveblomeley_at_yahooDOTco.uk>
Date: Thu, 19 Oct 2000 01:47:21 +0100
Message-ID: <39EE4498.43199F22@yahooDOTco.uk>

Ethan,

> Should I use a table and put a flag in it?
Have you considered using the DBMS_LOCK package (documented in the supplied packages reference manual). Your procedure could request an exclusive lock before running the main body of code - If it gets the lock OK, it runs the code then releases the lock; If it can't get the lock the procedure does nothing (ie: it assumes another session is already running the procedure)

Regards
Steve Blomeley Received on Wed Oct 18 2000 - 19:47:21 CDT