RE: Pl/sql loop assistance

> -----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