Home » SQL & PL/SQL » SQL & PL/SQL » Dropping a procedure (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
Dropping a procedure [message #552458] Thu, 26 April 2012 00:50 Go to next message
saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad
Senior Member

Hi All ,

When the procedure is executing can we drop a procedure .
Is there any way to drop the procedure with force .

Please help me

Thanks
SaiPradyumn

Report message to a moderator

Re: Dropping a procedure [message #552459 is a reply to message #552458] Thu, 26 April 2012 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68764
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
When the procedure is executing can we drop a procedure .


No.

Quote:
Is there any way to drop the procedure with force .


No.

Regards
Michel

Report message to a moderator

Re: Dropping a procedure [message #552558 is a reply to message #552459] Thu, 26 April 2012 08:48 Go to previous messageGo to next message
chandan.rattan
Messages: 84
Registered: December 2008
Location: India
Member
Correct Michel

Report message to a moderator

Re: Dropping a procedure [message #552559 is a reply to message #552558] Thu, 26 April 2012 08:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You may not be able to drop procedure even after is has completed running.
If/when procedure does DML, then procedure can not be dropped until pending transaction has been COMMITTED or ROLLBACK.

Report message to a moderator

Re: Dropping a procedure [message #552627 is a reply to message #552559] Fri, 27 April 2012 01:55 Go to previous messageGo to next message
saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad
Senior Member
Hi All ,

Is there any way to kill the process with force while executing .

I have a situation like one procedure is executing for so long time.So I killed the process in pl/sql developer tool .
There is possiblity of re writing the logic to improve the performance.
So just I want to kill/drop the existing procedure execution
and want to implement the new logic .

But it's not allowing to do any kind of such activity for certain time .

Please help me

Thanks
SaiPradyumn

Report message to a moderator

Re: Dropping a procedure [message #552636 is a reply to message #552627] Fri, 27 April 2012 02:42 Go to previous message
cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester
Senior Member
All you can do is kill the session that's running the procedure.
Once the session is killed it's outstanding transactions have to be rolled back.
You won't be able to replace the procedure until that rollback is complete.

Report message to a moderator

Previous Topic: problem in renaming a column
Next Topic: Converting number to string
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Aug 01 12:48:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.