[Err] ORA-24344: success with compilation error

1.建表
create table traback(
tra_id int primary key,
tra_usr_number nvarchar2(20) not null,
tra_usr_ent_id int,
tra_usr_display_bil nvarchar2(20),
tra_content nvarchar2(2000) not null,
tra_create_timestamp timestamp,
tra_source nvarchar2(10)
);

2.建序列
create sequence tra_back
increment by 1
start with 1
nomaxvalue
minvalue 1
nocycle;

3.建触发器
create or replace trigger tra_back before insert or update on traback
for each row
begin
if inserting then
–:new.tra_create_timestamp := systimestamp;
select sysdate into :new.tra_create_timestamp from dual;
elsif updating then
–:new.tra_create_timestamp := systimestamp;
select sysdate into :new.tra_create_timestamp from dual;
end if;
end;

创建触发器时报错的两个解决方案：
[Err] ORA-24344: success with compilation error

1.最后一个end要写在和倒数第二行同行：end if;end;
2.列名大写