Hi,

Did I misunderstand Mr. Galia question ?
if he want to do something like:
insert into test1 ...
insert into test2...
update auditlog ....
insert into test3
...
rollback;
...
if he want to rollback all INSERT statements and just keep the UPDATE statement committed, then it could not be done by savepoint. Am I right ?

Thanks, Wilfred


>Yes you can with savepoints...
>
>best illustrated with an example..
>
>

>savepoint statement1;
>insert into mytable values(1);
>if error then rollback to statement1;
>
>savepoint statement2;
>insert into mytable values(-1);
>if error then rollback to statement2;
>
>

>
>hth