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.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Oct 03 2007 - 01:56:56 CDT
