drop table dropme_child purge;
drop table dropme_parent purge;
create table dropme_parent(id primary key) as select rownum from dual connect by level < 10;
create table dropme_child(ref_id) as select 2*(1+mod(rownum,3)) from dual connect by level < 10;
alter table dropme_child add constraint dropme_fk foreign key(ref_id) references dropme_parent(id);

set serveroutput on

declare type ltt is table of rowid index by binary_integer;
  lt ltt;
  dml_error exception;
  pragma exception_init(dml_error, -24381);
  l_err_cnt number;
begin
  select rowid bulk collect into lt
    from dropme_parent
   where id < 5;
  forall i in 1..lt.count save exceptions
    delete dropme_parent where rowid = lt(i);
exception
  when dml_error then
    l_err_cnt := sql%bulk_exceptions.count;
    for i in 1..l_err_cnt loop
      dbms_output.put_line('rowid="'|| lt(sql%bulk_exceptions(i).error_INDEX)||'", error= -'||sql%bulk_exceptions(i).error_code
      );
    begin
        execute immediate 'delete dropme_parent where rowid = :1'
          using lt(sql%bulk_exceptions(i).error_INDEX);
      exception
        when others
          then
            dbms_output.put_line(sqlerrm);
    end;
    end loop;
end;
/
rowid="AAANVBAAEAAAAMMAAB", error= -2292
ORA-02292: integrity constraint (SCOTT.DROPME_FK) violated - child record found
ORA-24381: error(s) in array DML
rowid="AAANVBAAEAAAAMMAAD", error= -2292
ORA-02292: integrity constraint (SCOTT.DROPME_FK) violated - child record found
ORA-24381: error(s) in array DML

PL/SQL procedure successfully completed.

SQL>