Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I know whether procedure is running or not ?
Thanks for your answers.
>Just a guess, but are you trying to prevent more a procedure from
being
>executed more than once at the same time? If so then use the DBMS_LOCK
>package to get an exclusive lock when the procedure starts, and
release
>at the end.
Right guess. That's what I need to prevent, anyway for me it's useful
also
to know if a procedure has finished its job, so thanks for the other
replies too.
Regards
Francesco
Received on Fri Feb 18 2005 - 05:34:34 CST