Hi Gurus,
while inserting the records into the table through FORALL statement we are getting the below error.
"=Problem in Data Insertion ERROR:ORA-22160: element at index [1034] does not exist"
--> 40000 thousand records will be fetched from cursor using bulk collect with limit clause.
--> In FORALL using SAVE EXCEPTIONS inserting the records into the TABLE.
--> In exception block we used BULK_ERRORS user defined exceptions as below
bulk_errors EXCEPTION;
PRAGMA EXCEPTION_INIT(bulk_errors, -24381);
FORALL r IN 1 .. exposureConref_tab.LAST
SAVE EXCEPTIONS ---R14.0.3
INSERT /* + APPEND */ INTO table_name
(col1,col2,col3)
select col1,col2,col3 from table2 where col1=exposureConref_tab(r);
please let us how to resolve the above issue.
Thanks
---------
Rock_1986