Re: "savepoint" feature

On Thu, 12 Jul 2007 19:30:49 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>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.
>
>In full agreement with Brian, Sybrand, and Mark but the issue here
>is that instead of asking how to rollback past a commit you have
>fixated on the wrong solution ... savpoints.
>
>Take a look at Flashback Query, Flashback Table, Flashback Transaction,
>and Flashback Version. One or more of them, in 10g, can be utilized to
>do what you wish.

I agree with you. While I do believe this can be done on ad-hoc basis, I don't believe this can be programmed, as it would involve changing the procedures he can't change.

-- 
Sybrand Bakker
Senior Oracle DBA