黑马学习的 ORACLE触发器无效且未通过重新验证

[poppyblue]

代码内容：创建触发器
create or replace trigger auid
before
insert on
person
for each row
declare

begin
select s_person.nextval into :new.pid from dual;
end;
创建表：create sequence s_person;

create table person(
pid number(25),
pname varchar2(10)
);
操作：
insert into person values (1,'a');
commit;

[poppyblue]

报错一直是 ORACLE触发器无效且未通过重新验证

[poppyblue]

trigger电池也是没有红叉额

[nayi_224]

按顺序执行了一下，没有问题

create sequence s_person;
create table person(
       pid number(25),
       pname varchar2(10)
);

create or replace trigger auid
before
insert on
person
for each row
declare

begin
  select s_person.nextval into  :new.pid from dual;
end; 

  insert into person  values (-1,'a');
  insert into person  values (-1,'a');
  insert into person  values (-1,'a');
  insert into person  values (-1,'a');
  commit;
;

select * from person;
truncate table person;