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: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 24 Nov 2005 17:47:55 -0000
Message-ID: <MPG.1df00d224ca2100098a03c@news.individual.net>


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

-- 

jeremy
Received on Thu Nov 24 2005 - 11:47:55 CST

Original text of this message

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