OraFAQ Forum: SQL & PL/SQL » Doubts in Procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Doubts in Procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Doubts in Procedure [message #264706]

Tue, 04 September 2007 04:55

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

Report message to a moderator

Re: Doubts in Procedure [message #264709 is a reply to message #264706]

Tue, 04 September 2007 04:57

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!!

Report message to a moderator

Re: Doubts in Procedure [message #264732 is a reply to message #264706]

Tue, 04 September 2007 06:30

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Doubts in Procedure [message #265045 is a reply to message #264709]

Wed, 05 September 2007 05:39

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 17 03:31:31 CDT 2025