LOG ERRORS INTO

CREATE TABLE T 
(
 myid NUMBER, 
 aaaa VARCHAR2(10),
 bbbb VARCHAR2(10)
);

CREATE TABLE T2 
(
 myid NUMBER, 
 aaaa VARCHAR2(10),
 bbbb NUMBER
);

create table MY_ERROR_INFO
(
  ora_err_number$ NUMBER,
  ora_err_mesg$   VARCHAR2(2000),
  ora_err_rowid$  ROWID,
  ora_err_optyp$  VARCHAR2(2),
  ora_err_tag$    VARCHAR2(2000),
  myid            NUMBER
)

INSERT INTO T(MYID,AAAA,BBBB) VALUES (1, '1','2');

INSERT INTO T(MYID,AAAA,BBBB) VALUES (2, '2','21234567890')
LOG ERRORS INTO MY_ERROR_INFO('T_ERR') REJECT LIMIT UNLIMITED;

select *  from t;

INSERT INTO T(MYID,AAAA,BBBB) VALUES (3, '3','a');

select * from MY_ERROR_INFO

insert into T2(MYID,AAAA,BBBB)
select myid,aaaa,to_number(bbbb) as bbbb from t
LOG ERRORS INTO MY_ERROR_INFO('T_ERR') REJECT LIMIT UNLIMITED;