My program is a critical reporting called thro ksh script.
I want to ensure that in no case all insert data gets rolled backed due to any data issue or ora errors.

1.How to ensure that inserts which have failed in exception block are ignored
and successful inserts will commit outside cursor loop.
2.Do you need to handle exception when others for each insert stmts
in the cursor loop.
3.If cursor data vaolume is high do I need commit after nth record at a time.
Normally our project programs log errors to a os file using utl_file thro a separate stored procedure.

4.Assuming I commit after every 5000/nth record in cursor loop.
Can pl/sql for this sample example ensure that all dmls will be part of a single transaction .

Note:I've lot of select stmts and select on max column values before I insert into table in cursor loop.

5.What is the best practice we can employ in pl/sql
when inserted table data is being used for reporting purpose (BO reports )
and being monitored closely

1.declare a cursor on tables (A,B,C)
2.open cursor
3.fetch cursor in a loop
begin
insert into table D
exception
when others
log into exception table
end;
if rec cnt = 5000
commit;
end if;
end loop;
close cursor;

update control table
where clause

commit;