Hi all,
One of my customer is using bulk insert and forall statement to insert into a table.After debugging I found that "ORA-01722: invalid number" is happening. But after capturing all the values in the array, I find that the values in the array are matching the col types to be inserted. Please help!!!

This is the code:

FORALL i IN I_PVT.NODES_LIST.FIRST..NODES_LIST.LAST SAVE EXCEPTIONS
insert into RT_NODES values I_PVT.NODES_LIST(i);
exception
WHEN array_dml_errors THEN
errors := SQL%BULK_EXCEPTIONS.COUNT;
FOR i IN 1..errors LOOP
variable := SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);


Following up to the bulk insert problem mentioned earlier..I modified the following..
forall list(i).first..list(i).last
insert into table values list(i);"

to
for i in 1..list(i).count loop
insert into table (col1,col2..) values
(list(i).col1,list(i).col2,list(i).col3..);
end loop;

Earlier I was getting an "invalid number" error. But now I am getting a "no data found" error in the exception handler.

Experts, please advise on the possible scenarios where the problem could be and how to override this.