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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Pl/sql loop assistance

RE: Pl/sql loop assistance

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 10 May 2001 09:50:53 -0700
Message-ID: <F001.002FF7DC.20010510090650@fatcity.com>

> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_cybcon.com]
>
> I'll have to disagree with not using commit within a loop.
>
> If you identify what a transaction is within your code, and
> write it accordingly, using commit where appropriate, you
> will not get ORA-1002 or ORA-1555, at least not due
> to your own code.

This reminds me, Mr. Still, you posted an example once to the list about doing a fetch in rowid order to avoid revisiting the same block when doing a full table scan of a table, so that reading and updating every row in a table would avoid the dreaded "snapshot too old". I told a developper about that today and showed him a code sample, but he says he still had a "snapshot too old". Would it be possible for you to post that snippet of code again?

Jacques R. KilchoŽr
x8816 Received on Thu May 10 2001 - 11:50:53 CDT

Original text of this message

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