Re: Check if Oracle stored procedure already running

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 13 Jul 2006 21:49:38 +0100
Message-ID: <6ccdb29ac52ol356eaj9qvergn16dage37@4ax.com>

On 13 Jul 2006 07:19:03 -0700, darkmichael_at_yahoo.com wrote:

>Could you please give an advise how I can check whether an Oracle
>stored procedure is already running to prevent it to run again?

If you mean that only a single session may run this procedure at any time, one of several options is to take a user-defined lock using DBMS_LOCK.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Thu Jul 13 2006 - 15:49:38 CDT