Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tab (name varchar2 (8) primary key, val int check (val<15))
declare
    type tabrows is table of tab%rowtype;
    newrows tabrows;
    cursor cur is
        select 'aaa',  5 from dual union all 
        select 'bbb', 10 from dual union all 
        select 'ccc', 15 from dual;
begin   
    open cur;
    fetch cur bulk collect into newrows;

    forall i in indices of newrows save exceptions 
        insert into tab values (newrows(i).name,newrows(i).val); 
end;
/
ORA-24381: error(s) in array DML
ORA-06512: at line 12

select * from tab


NAME
VAL


aaa
5

bbb
10


rollback
create table errlog (tabname varchar2 (8), key varchar2 (96), errm varchar2 (256))
declare
    type tabrows is table of tab%rowtype;
    newrows tabrows;
    cursor cur is     
        select 'aaa',  5 from dual union all 
        select 'bbb', 10 from dual union all 
        select 'ccc', 15 from dual;
begin   
    open cur;
    fetch cur bulk collect into newrows;
    declare
        dmlerr exception;
        pragma exception_init (dmlerr, -24381);
        errkey varchar2 (8);
        errmsg varchar2 (256);
    begin
        forall i in indices of newrows save exceptions 
            insert into tab values (newrows(i).name,newrows(i).val); 
    exception when dmlerr then null;
        for i in 1..sql%bulk_exceptions.count loop
            errkey := newrows(sql%bulk_exceptions(i).error_index).name; 
            errmsg := sqlerrm (-(sql%bulk_exceptions(i).error_code));
            insert into errlog values ('tab', errkey, errmsg);
        end loop;
    end;
end;
/
1 rows affected

select * from tab


NAME
VAL


aaa
5

bbb
10


select * from errlog


TABNAME
KEY
ERRM


tab
ccc
ORA-02290: check constraint (.) violated