Re: Stop a PL/SQL stored procedure
Date: Thu, 06 Sep 2007 06:41:01 -0700
> 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,
> (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.orgReceived on Thu Sep 06 2007 - 15:41:01 CEST