Home » SQL & PL/SQL » SQL & PL/SQL » Doubts in Procedure
icon7.gif  Doubts in Procedure [message #264706] Tue, 04 September 2007 04:55 Go to next message
oracleram
Messages: 23
Registered: November 2006
Junior Member
Hi Every1,

i have one procedure,i have one doubt,if suppose there is system error while execyting that procecudre means what will happen?whether the procedure get executed or not?how i want to overcome that problem,i need to commit only there is no errors,if there is errors means there will be no changes,pls help me in this doubt,Thanx in advance...


Thanks & Regards,

Ram
Re: Doubts in Procedure [message #264709 is a reply to message #264706] Tue, 04 September 2007 04:57 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You need not to bother with it. Oracle knows better than you. When to rollback and when to commit!!
Re: Doubts in Procedure [message #264732 is a reply to message #264706] Tue, 04 September 2007 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i have one procedure,i have one doubt,if suppose there is system error while execyting that procecudre means what will happen?

It depends which kind of failure. If it is a system/instance crash Oracle will roll back the changes made (and not committed) by the procedure at instance restart.

Regards
Michel
Re: Doubts in Procedure [message #265045 is a reply to message #264709] Wed, 05 September 2007 05:39 Go to previous message
oracleram
Messages: 23
Registered: November 2006
Junior Member
HI,

Thank for help....

Thanks & Regards,

Ram

[mod-edit] removed illiterate IM speak.

[Updated on: Wed, 05 September 2007 08:05] by Moderator

Report message to a moderator

Previous Topic: doubt in rownum
Next Topic: Resolving dead lock error
Goto Forum:
  


Current Time: Fri Dec 02 22:49:39 CST 2016

Total time taken to generate the page: 0.06996 seconds