cavalcantipino (AT) yahoo (DOT) it wrote:
Quote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org