Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in Data Insertion ERROR:ORA-22160: element at index [1034] does not exist

rock_1986Mar 10 2016 — edited Mar 10 2016

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2016
Added on Mar 10 2016
3 comments
2,643 views