Oracle 在插入过程中处理旁路故障并继续

Begin
insert into table () values();
insert into table () values();
.
.
.
commit;
end;
复制

create table t (
  c1 int primary key 
);

exec dbms_errlog.create_error_log (dml_table_name => 't');

begin
  insert into t values ( 1 )
    log errors reject limit unlimited;
  insert into t values ( 2 )
    log errors reject limit unlimited;
  insert into t values ( 1 )
    log errors reject limit unlimited;
  insert into t values ( 'a' )
    log errors reject limit unlimited;
  insert into t values ( 3 )
    log errors reject limit unlimited;
end;
/

select * from t;

C1   
    1 
    2 
    3 

select c1, ora_err_mesg$ 
from   err$_t;

C1    ORA_ERR_MESG$                                                 
1     ORA-00001: unique constraint (CHRIS.SYS_C0019292) violated
a     ORA-01722: invalid number
复制