Hi Experts,

CREATE OR REPLACE PROCEDURE proc20

IS

TYPE Type1 IS TABLE OF cust_src_tbl.cust_att%TYPE PLS_INETGER;

vc TYPE1;

bulk_exception EXCEPTION;

v_error_count NUMBER;

v_error_msg VARCHAR2(100);

PRAGMA EXCEPTION_INIT(bulk_exception,-24381);

CURSOR C IS

select cust_att from cust_src_tbl ;

BEGIN

OPEN c;

FETCH C BULK COLLECT INTO VC LIMIT 1000;

CLOSE C;

FORALL i IN 1..VC.count save exceptions

INSERT INTO cust_target_tbl()

SELECT

where

commit;

EXCEPTION

WHEN bulk_exception THEN

v_error_count:= SQL%BULK_EXCEPTIONS.count();

FOR i iN 1..v_error_count

LOOP

v_error_msg:=Error' ||SQL%BULK_EXCEPTIONS(i).error_index() || sqlerrm(SQL%BULK_EXCEPTIONS(i).error_code());