Re: Row counts for FORALL

In article <1191394603.952701_at_bubbleator.drizzle.com>, damorgan_at_psoug.org says...
> Dereck L. Dietz wrote:
> > Oracle 10.2.0.3.0, Windows 2003 server
> >
> > With the insert below is there any way, other than doing a SELECT COUNT(*)
> > after all the rows are inserted, to get a count of rows which have gone into
> > the HMP_LOAD_DATES table and not the ERR$_HMP_LOAD_DATES table?
> >
> > FORALL v_row IN INDICES OF v_dates_rec
> > INSERT INTO hmp_load_dates VALUES v_dates_rec(v_row)
> > LOG ERRORS INTO err$_hmp_load_dates
> > REJECT LIMIT UNLIMITED;
> >
> > v_load_cnt := v_load_cnt + v_dates_rec.COUNT;
>
> SQL%BULK_ROWCOUNT
>
> Demo in Morgan's Library at www.psoug.org under Array Processing.
>

Nice...

Dereck, could you confirm that SQL%BULK_ROWCOUNT is indeed 0 for a logged insert ?

Just curious.... Thanks much Received on Wed Oct 03 2007 - 12:47:24 CDT