Re: for d in c loop; insert; commit ...

Ooops. Forgot to mention this is an old database (probably started with version 6) with some major work done when they moved to 8i on Solaris. Currently running 9.2.0.8 on Linux x86_64. Perhaps this made sense in an older version?

On 8/15/07, stv <stvsmth_at_gmail.com> wrote:
> Why in the world did I inherit a database with all this nonsense everywhere ...
>
> lc := 0;
> For d in C loop
> lc := lc + 1;
> # insert stuff
> if mod(lc, 50) = 0 then commit; end if;
> end loop;
> commit;

--
http://www.freelists.org/webpage/oracle-l