Re: Stop a PL/SQL stored procedure

cavalcantipino_at_yahoo.it wrote:
> In Oracle Sql Developer how can I stop a PL/SQL stored procedure that
> take long time to finish?
> Can I execute a sql command to stop that? What's the command?
>
> Thank you in advance,
>
> Pino
> (The oracle newbie)

Assuming client-server in a normal development environment the only thing you can do is ask the DBA to kill it. If you have privileges to kill it yourself any of these methods will work: http://www.psoug.org/reference/kill_session.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org