Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "best" option to abort a running stored proc
On Sep 21, 9: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
As the other respondents made clear, your requirement is a little
vague. Perhaps you may like to use the timeout parameter of
DBMS_PIPE.RECEIVE_MESSAGE (see e.g.
http://www.cs.umbc.edu/help/oracle8/server.815/a68001/dbms_pip.htm#1003366)
and in case the call to this function then returns with return value
equals 1, you could e.g. raise an exception in the calling pl/sql
body, effectively stopping the "running stored procedure" or do
something else. Good luck and let us know how you are tackling this.
You may also benefit from dbms_alert, I am not sure whether dbms_pipe
is deprecated - for some reason it is not in DA Morgan's library.
Regards, Erik Ykema
Received on Sat Sep 22 2007 - 14:49:02 CDT