oracle触发器如何阻住插入,但是不要抛异常?

比如我插入100条数据,其中有一条数据有问题不进行插入,但是也不要抛异常,只要忽略掉有问题的数据就好了,其他正常的数据照常插入,触发器要怎么写?

我这么写好像没有效果,数据还是插入成功了!

create or replace trigger TR_MED_PATIENT_SCHEDULE
  before
  insert or update
  on MED_PATIENT_SCHEDULE
  referencing new as new old as old
  for each row
declare
  VCOUNTER    number;
begin
  select count(1) into VCOUNTER from MED_PATIENT_SCHEDULE where HEMODIALYSIS_ID=:new.HEMODIALYSIS_ID and DIALYSIS_DATE=:new.DIALYSIS_DATE and BANCI_ID=:new.BANCI_ID;
  if VCOUNTER>0 then
    rollback;
  end if;
end;