Stop a PL/SQL stored procedure

Stop a PL/SQL stored procedure

Post by cavalcanti » Fri, 07 Sep 2007 18:34:26


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)
 
 
 

Stop a PL/SQL stored procedure

Post by DA Morga » Fri, 07 Sep 2007 22:41:01


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.yqcomputer.com/
--
Daniel A. Morgan
University of Washington
XXXX@XXXXX.COM (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

 
 
 

Stop a PL/SQL stored procedure

Post by cavalcanti » Sun, 09 Sep 2007 00:24:57

Thank you. I'll try as soon as possible.

Pino