userjohn wrote:
>
> 10gR2 EE (10.2.0.3.0) /Solaris
>
> what is the "best" option to abort a running stored proc, dbms_pipe ?
>
> thanks
I'm guessing you are using the stored proc as some sort of daemon
process. If that's the case, then dbms_pipe, dbms_aq or dbms_alert all
work without too much fuss.
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"Semper in excremento, sole profundum qui variat."
------------------------------------------------------------
Received on Tue Sep 25 2007 - 07:48:21 CDT
