Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: nested savepoint
>
>I'm having some problems understanding commit in the following case
>
>savepoint A
>
>"insert into database"
>
>savepoint B
>"insert into database"
>commit ( will commit all changes made up to this point)
>
>
>now if I try to :
>rollback A
>
>will it actually work or once a commit has been executed,there is not an
>option to rollback to A
>
>steve
>
>
>
>
>
>
Hi,
Once you commit, rollback has no effect on the committed transaction.
.
Received on Fri Jan 14 2000 - 14:04:59 CST
![]() |
![]() |