OraFAQ Forum: Forms » How can we rollback back once we commited

Home » Developer & Programmer » Forms » How can we rollback back once we commited (oracle 11g,version:11.1.0,windows XP2)

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

How can we rollback back once we commited [message #556341]

Sat, 02 June 2012 02:03

vickyminugmailcom
Messages: 54
Registered: October 2011
Location: banglore

Member

hi,
could some one help me how to rollback back again when once it is commited and is there any chance to use rollback if once commit is used.

regards,
vvr

Report message to a moderator

Re: How can we rollback back once we commited [message #556346 is a reply to message #556341]

Sat, 02 June 2012 03:03

John Watson
Messages: 8938
Registered: January 2010
Location: Global Village

Senior Member

Impossible.

Report message to a moderator

Re: How can we rollback back once we commited [message #556347 is a reply to message #556346]

Sat, 02 June 2012 03:08

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Which is to say rollback rolls back uncommitted changes.
If you don't want to make a change permanent don't commit it in the first place.

Report message to a moderator

Re: How can we rollback back once we commited [message #556350 is a reply to message #556347]

Sat, 02 June 2012 03:22

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And this is why you must NOT commit inside a procedure because then the caller cannot roll back what it did before calling the procedure and what the procedure did.

Regards
Michel

Report message to a moderator

Re: How can we rollback back once we commited [message #556353 is a reply to message #556350]

Sat, 02 June 2012 04:56

vickyminugmailcom
Messages: 54
Registered: October 2011
Location: banglore

Member

Thank you

Report message to a moderator

Re: How can we rollback back once we commited [message #557385 is a reply to message #556353]

Tue, 12 June 2012 06:37

abrarji
Messages: 8
Registered: June 2012
Location: Pakistan

Junior Member

Yes, you can rollback data using flash back recovery method.... But keep in mind put that query in flash back which you used in form, for inserting.

Report message to a moderator

Re: How can we rollback back once we commited [message #557386 is a reply to message #557385]

Tue, 12 June 2012 06:37

abrarji
Messages: 8
Registered: June 2012
Location: Pakistan

Junior Member

Yes, you can recover data using flash back recovery method.... But keep in mind put that query in flash back which you used in form, for inserting.

Report message to a moderator

Re: How can we rollback back once we commited [message #557387 is a reply to message #557386]

Tue, 12 June 2012 06:44

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

try flashback version and transaction query.may be it work.

regards
pritesh ranjan

Report message to a moderator

Re: How can we rollback back once we commited [message #557389 is a reply to message #557387]

Tue, 12 June 2012 06:46

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

but in this method u must expectly enter the data that u get after the version and transaction query. not rollback.

thanks
pritesh ranjan

Report message to a moderator

Previous Topic:	Can we use RAISE FORM_FAILURE_TRIGGER in EXCEPTION
Next Topic:	Update impossible

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 21:56:34 CDT 2024