Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Check if Oracle stored procedure already running

Re: Check if Oracle stored procedure already running

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 13 Jul 2006 10:25:00 -0700
Message-ID: <1152811500.238195.47670@b28g2000cwb.googlegroups.com> 






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




Hi Michael,



I wasn't sure what you meant by "prevent it to run again".  Do you mean
it can't be run again in the same session, or across the instance, or
forever?



Regards,



Steve
Received on Thu Jul 13 2006 - 12:25:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US