Re: for d in c loop; insert; commit ...
- From: stv <stvsmth@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 15 Aug 2007 17:01:11 -0600
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@xxxxxxxxx> 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;
--
//www.freelists.org/webpage/oracle-l
Other related posts:
