Re: How do I know whether procedure is running or not ?

fmarchioni_at_libero.it wrote:

> Hi all!
> Can anybody point out how to check if a stored procedure
> is executing ? (Is there a table which contains references
> to objects which are in execution ?)
> Thanks a lot
> Francesco

To do this you need to write your procedure properly ... which means putting a call to DBMS_APPLICATION_INFO.SET_MODULE as the first line of code after BEGIN.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)