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.

David Fitzjarrell

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.

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

If your aim is to kill off "runaway" procedures, you can
set it up to run under an Oracle user w/ a profile that
limits the CPU in a session.  See:
http://www.psoug.org/reference/profiles.html

Of course that will kill off the session, not just the
stored proc, which may be less graceful than what you want.
But at least it will happen (eventually) in an automatic
way.  Your other option as mentioned by others is to kill
off the session manually w/ ALTER SYSTEM KILL SESSION

John Hinsdale

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.