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

From: Palooka <nobody_at_nowhere.com>
Date: Sat, 29 Sep 2007 18:19:56 GMT
Message-ID: <gHwLi.4110$Qd2.3269@newsfe6-win.ntli.net>

"Connor McDonald"
>> 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.
>

I've used dbms_pipe for years for this type of thing. Lightweight, and works with all versions.

Palooka Received on Sat Sep 29 2007 - 13:19:56 CDT