--新增触发器,当新增险种时记入接口日志表
create or replace trigger LMRisk_trigger
before insert or update on LMRisk
for each row
declare
ip varchar2(20);
currdate date;
begin
select SYSDATE into currdate from dual;
MERGE INTO ldinterfacelog a USING ( select :new.riskcode as riskcode from dual) du ON(a.otherno=du.riskcode)
WHEN NOT MATCHED THEN INSERT
Values (:new.riskcode,'LMR',:new.riskcode,'','',currdate,'00:00:00') ;
end LMRisk_trigger;
/
create or replace trigger LMRisk_trigger
before insert or update on LMRisk
for each row
declare
ip varchar2(20);
currdate date;
begin
select SYSDATE into currdate from dual;
MERGE INTO ldinterfacelog a USING ( select :new.riskcode as riskcode from dual) du ON(a.otherno=du.riskcode)
WHEN NOT MATCHED THEN INSERT
Values (:new.riskcode,'LMR',:new.riskcode,'','',currdate,'00:00:00') ;
end LMRisk_trigger;
/