OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Rollback

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

Rollback [message #202817]

Sun, 12 November 2006 23:38

ashutosh_1116
Messages: 5
Registered: November 2006
Location: India

Junior Member

Suppose we have created four savepoint i.e s1,s2,s3 and s4.
I want to Rollback s2 to s1.How we can Rollback this?

Report message to a moderator

Re: Rollback [message #202825 is a reply to message #202817]

Mon, 13 November 2006 00:20

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Without rolling back savepoints s3 and s4, you can't.

Savepoints are cumulative.

Search the doco for AUTONOMOUS TRANSACTION. It might be what you are looking for.

Ross Leishman

Report message to a moderator

Re: Rollback [message #203160 is a reply to message #202825]

Tue, 14 November 2006 02:41

ashutosh_1116
Messages: 5
Registered: November 2006
Location: India

Junior Member

Thanks for answering me.

Report message to a moderator

Previous Topic:	select date
Next Topic:	ORA-00979: not a GROUP BY expression

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 19:37:13 CST 2024