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: 01555 and select statement

Re: 01555 and select statement

From: <xhoster_at_gmail.com>
Date: 10 May 2006 22:19:51 GMT
Message-ID: <20060510183715.154$iC@newsreader.com>


niy38_at_hotmail.com wrote:
> even I have ora-1555 error, I still can run couple of times to update
> all record if
> commit inside loop.

If you commit inside the loop and run it a couple of times due to 1555, then some records will be update more once!

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB
Received on Wed May 10 2006 - 17:19:51 CDT

Original text of this message

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