Question

oracle 插入触发器报 ORA-04071: 缺失 BEFORE, AFTER 或 INSTEAD OF 关键字

create trigger trixzspService
ON XZSP_SERVICE
for insert
as
begin
insert into TB_YY_ITEM(ITEM_ID,ITEM_NAME,GROUP_ID)
select ITEM_ID,ITEM_NAME,GROUP_ID from inserted;
end
想在XZSP_SERVICE插入一条数据时，TB_YY_ITEM添加其插入数据的其中三个字段的数据，这么写有什么问题，要怎么改？

Answer 1

create or replace trigger trizspService
before insert on XZSP_SERVICE
begin
insert into TB_YY_ITEM(ITEM_ID,ITEM_NAME,GROUP_ID)
select ITEM_ID,ITEM_NAME,GROUP_ID from inserted;
end;
如果是insert之前触发就是before, 否则就是after

Answer 2

create trigger trixzspService before on XZSP_SERVICE

追问

报ORA-04072: 无效的触发器类型

追答

create trigger trixzspService before insert on XZSP_SERVICE for each row
begin
insert into TB_YY_ITEM(ITEM_ID,ITEM_NAME,GROUP_ID)
select ITEM_ID,ITEM_NAME,GROUP_ID from inserted;
end;