Re: "savepoint" feature

mike7411_at_gmail.com wrote:
> I am working with the "savepoint" feature in Oracle, and I noticed
> that a savepoint appears
> to get deleted when a commit occurs. I was wondering if these is an
> easy way to make
> a savepoint that will persist across commits.
>
> Any help is appreciated.
>
> Thank you.
>

A savepoint lets you roll back part of a transaction. Without a savepoint, the only option is to roll back the entire transaction. Once you commit the transaction, it can no longer be rolled back....in part nor in total. So it makes no sense to let you roll back to a savepoint in a committed transaction. This is not possible. If you think you need to rollback to that savepoint, then don't commit!

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com