create or replace PROCEDURE name_correction
  is CURSOR p_import_I is SELECT * FROM PERSONAL_IMP_I;
  rec_import_I p_import_I%ROWTYPE;
  name_error EXCEPTION;
  BEGIN
    open p_import_I;
      loop
        fetch p_import_I into rec_import_I;
          exit when p_import_I%NOTFOUND;
           BEGIN
            IF REGEXP_LIKE(rec_import_I.vorname, '[0-9]') OR REGEXP_LIKE(rec_import_I.nachname, '[0-9]')
             then RAISE name_error;
            END IF;
            Exception when name_error 
             then insert into log_table values (rec_import_I.id, 'Name enthält Zahlen', 'Namensprüfung', 'Personal_IMP_I',        
                   systimestamp);
                  commit;
  --Here i would like to correct the date of the field rec_import_I.vorname the the regexp_replace function, but how
           END;
           insert into personen_val_I values
                                  (rec_import_I.id, rec_import_I.vorname, rec_import_I.nachname,
                                  rec_import_I.email, rec_import_I.status, rec_import_I.aktiv,
                                  rec_import_I.vorgesetzter, rec_import_I.fachbereichs_id,
                                  rec_import_I.telefonnummer, rec_import_I.Lokation_ID);                  
    end loop;
   close p_import_I;
 END;

create or replace procedure name_correction
is 
  name_error exception;
begin
  for cur_r in (select * from personal_imp_i) loop
    begin
      if regexp_like(cur_r.vorname, '[0-9]') or ... then
         raisename_error;
      end if;
    exception when name_error then ...
    end;
    insert into personen_val_I values ...
  end loop;
end;