Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 9i SAVEPOINT question

Re: 9i SAVEPOINT question

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 24 Nov 2005 11:01:10 -0800
Message-ID: <1132861969.236090@yasure>


Jeremy wrote:
> In article <1132853035.237964_at_yasure>, DA Morgan says...
>

>>I think your use of savepoints is likely a bad idea. Take a look at
>>the DBMS_RESUMABLE built-in package. You can find it documented at
>>http://tahiti.oracle.com and a working demo in Morgan's Library at
>>www.psoug.org.
>>

>
>
> Hi Daniel, thanks for your response - I will certainly look at
> DBMS_RESUMABLE - I'd appreciate your thoughts on why the savepoint idea
> is "likely a bad idea" - will it work - perhaps it is not as efficient
> as other methods?
>
> Thanks

Savepoints are designed to solve a different problem. Could you get them to work? Perhaps but at a huge cost in terms of manual labor. It makes far more sense to use the tool designed for the job.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Nov 24 2005 - 13:01:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US