Oracle跨库数据库(触发器)

跨库数据库(触发器)

create or replace trigger trigger_unit_test
after insert on AUNIT
for each row
declare
-- local variables here
v_verb nvarchar2(20);
v_src nvarchar2(40);
v_tablename nvarchar2(40);
v_colname nvarchar2(40);
begin
v_tablename := 'AUNIT'; --需修改
v_colname := 'UNITID'; --需修改
if inserting then
v_verb:='insert';
v_src:= :NEW.UNITID; --需修改
--处理插入
insert into AUNIT_TEST@ORCL_88
(
UNITID,
NAME
)
values
(
:NEW.UNITID,
:NEW.NAME
);
end if;
exception
when others then
insert into trig_syncerror (colvalue,verb,tablename,colname) values (v_src,v_verb,v_tablename,v_colname);
end trigger_unit_test;