[在线等]ORACLE触发器编译错误,到底是我那地方写错了?
以下是我写的ORACLE触发器代码,编译的时候提示有编译错误,可惜小弟看不出来,希望有经验的哥哥姐姐帮忙看下,先谢谢了
create or replace trigger hr.biud_employees_copy
before insert or update or delete
on hr.employees_copy
declare
l_action employees_log.action %type;
begin
if inserting then
l_action :='insert';
else if updating then
l_action :='update';
else if deleting then
l_action :='delete';
else
raise_application_error(-20001,'You should never ever get this error');
end if;
insert into hr.employees_log(who,action,when)values(user,l_action,sysdate);
end ;
编译提示错误:
行号= 16 列号= 11 错误文本= PLS-00103: 出现符号 ";"在需要下列之一时: if