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
