Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Row counts for FORALL
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; Received on Tue Oct 02 2007 - 18:54:01 CDT
![]() |
![]() |