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

From: userjohn <userjohn_at_mailinator.com>
Date: Tue, 25 Sep 2007 16:46:36 -0400
Message-ID: <13fisvohu5ipl35@corp.supernews.com>

<fitzjarrell_at_cox.net> wrote in message
> Is a procedure in the dbms_pipe package what you want stopped? Or are
> you asking if dbms_pipe is the package to use to perform such a task?
> If it's the latter your question makes very little sense.
>

No no, it is NOT "procedure in the dbms_pipe package" that I want to stop/abort/terminate,
not Oracle packages. (LOL)

It is USER/MY stored procedure in pkg that I want to be able to stop/abort/terminate
FROM ANOTHER SESSION WHILE IT'S RUNNING I looked further into it and as Connor suggeste, dbms_alert serves this purpose. Received on Tue Sep 25 2007 - 15:46:36 CDT