Re: nested savepoint

Steve A <spectre_at_hkstar.com> a écrit dans le message : 1e4ac1b.12zf9w97gjxbuN@[192.168.2.71]...
> Hi,
>
> 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

If you try "rollback to a", you'll get: ERROR at line 1:
ORA-01086: savepoint 'A' never established

As a matter of fact, "commit" commits all the transaction from its beginning that is from the last commit or the start of the session. All the savepoints are cleared.

>
> will it actually work or once a commit has been executed,there is not an
> option to rollback to A
>
> steve
Received on Wed Jan 12 2000 - 06:53:53 CST