create database link arcms
connect to arcms identified by arcmsusing '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.210.235)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
before update on cz_notice
for each row
begin
if (:old.GG_STATUS = 3) then
insert into cms_content@arcms (CONTENT_ID,CATEGORY_ID,CONTENT_TITLE,PUBLISH_TIME,CONTENT_STATUS,CONTENT_TPL,CONTEXT_TYPE,PUBLISH_TYPE,END_TIME)
values(:old.seq_id,'8af652f3362e61bc01362e6d34ff0006',:old.GG_NAME,:old.PULISH_DATE,1,'/theme/default/content/default/article/content.tpl','Content',0,:old.DEADLINE);
end if;
end;