Please see the below code do i need to put commit after all DML...OR one Commit will work ..


if err_sacdm_cus.count>0 then
begin
forall i in err_sacdm_cus.first .. err_sacdm_cus.last save EXCEPTIONS
update customer
set dcmo_err_msg = lv_err_msg(i),
dcmo_processed = lv_processed(i),
dcmo_passed = lv_passed(i),
dcmo_process_date = sysdate
where ss_id = lv_ss_id (i)
and ss_name = lv_ss_name (i);
commit;



delete from sacdm_owner.gs_bfg_migration_cus
where (cus_dcmr_id, cus_sourcesystem) in
( select ss_id, ss_name from sacdm_owner.customer
where dcmo_processed + dcmo_passed = 1
);

commit;

exception
when others then
PKG_SACDM_DCMO_ERROR_LOG.PR_CREATE_ERROR_LOG
(
ENTITY_NAME => 'SACDM_OWNER.CUSTOMER',
RUN_IDENTIFIER => 1,
SS_ID => Null,
SS_NAME => null,
ERR_CODE => Null,
ERR_DESCRIPTION => SQL%BULK_EXCEPTIONS.COUNT || ' records failed duding bulk update'|| substr(sqlerrm,1,700),
ERR_SOURCE => 'PKG_SACDM_DCMO_CUSTOMER.PR_UPDATE_SACDM_CUS - forall update',
DML_STATEMENT => null
);
end;
end if;
commit;

if err_sacdm_cus.count>0 then
    begin
      forall i in err_sacdm_cus.first .. err_sacdm_cus.last 
              save          EXCEPTIONS                           
      update customer
....
      commit;
     
      delete from sacdm_owner.gs_bfg_migration_cus
...           
        commit; 
             
    exception
      when others then       
         null basically, do nothing
    end;
  end if;
  commit;