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: "best" option to abort a running stored proc

Re: "best" option to abort a running stored proc

From: <zigzagdna_at_yahoo.com>
Date: Fri, 21 Sep 2007 17:16:57 -0700
Message-ID: <1190420217.142885.278970@n39g2000hsh.googlegroups.com> 





On Sep 21, 3:05 pm, "userjohn" <userj..._at_mailinator.com> wrote:


> 10gR2 EE (10.2.0.3.0) /Solaris

>

> what is the "best" option to abort a running stored proc, dbms_pipe ?

>

> thanks




You are proably asking if a stored procedure is running and takes long
time, you want to kill it. I guess you can kill
the process or session running the stored procedure.
Received on Fri Sep 21 2007 - 19:16:57 CDT












Original text of this message













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