Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Row counts for FORALL

Row counts for FORALL

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 02 Oct 2007 23:54:01 GMT
Message-ID: <tSAMi.11084$JD.10224@newssvr21.news.prodigy.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US