Re: Check if Oracle stored procedure already running

darkmich..._at_yahoo.com wrote:
> Hello,
>
> Could you please give an advise how I can check whether an Oracle
> stored procedure is already running to prevent it to run again?
>
> Thanks in advance.
>
> Michael

The easiest way is to wrap the procedure in a package, and have it set a variable defined in the package spec.
Other invocations of the procedure would need to verify whether the variable was already set.

-- 
Sybrand Bakker
Senior Oracle DBA