dbTalk Databases Forums  

Stop a PL/SQL stored procedure

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Stop a PL/SQL stored procedure in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
cavalcantipino@yahoo.it
 
Posts: n/a

Default Stop a PL/SQL stored procedure - 09-06-2007 , 04:34 AM






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)


Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: Stop a PL/SQL stored procedure - 09-06-2007 , 08:41 AM






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


Reply With Quote
  #3  
Old   
cavalcantipino@yahoo.it
 
Posts: n/a

Default Re: Stop a PL/SQL stored procedure - 09-07-2007 , 10:24 AM



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

Pino


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.