比如我插入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;