| Question on savepint [message #572417] |
Tue, 11 December 2012 16:57  |
 |
bobbyjohnz
Messages: 1
Registered: December 2012
Location: Australia
|
Junior Member |
|
|
Scenario
begin
savepoint a;
statement 1;
savepoint b;
statement 2;
end;
After completing statement 2, is there a way I can commit statement 2 alone but want to rollback statement 1?
Per what I know, if I do a commit after statement 2 both statements 1 and 2 will get committed while if I do a rollback to savepoint a both the statements will get rolled back.
To put the question in another way, can I use something like 'commit to savepoint b' similar to the statement 'rollback to savepont b' ?
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
