How can i check if a oracle stored procedure is already already running
-
-
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.
One more solution
Assuming you are talking about it being run
in the current session: Here's another.
DBMS_APPLICATIO N_INFO.SET_CLIE NT_INFO
DBMS_APPLICATIO N_INFO.GET_CLIE NT_INFO
A demo can be found in Morgan's Library at http://www.psoug.org/
Obtained from http://dbaspot.com/forums/oracle-ser...y-running.html
Hope this helps
Comment