Re: Check if Oracle stored procedure already running

darkmichael_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

Sybrand offers one solution. Assuming you are talking about it being run in the current session: Here's another.

DBMS_APPLICATION_INFO.SET_CLIENT_INFO
DBMS_APPLICATION_INFO.GET_CLIENT_INFO A demo can be found in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org