insert into temp_table values( class_seq.nextval,'ddfdfdf');没有temp_table 这个表吧!
还是不行create table class2 (Cno int, Cch varchar2(500));SQL> create or replace trigger class_trigger2 2 after insert on class2 3 begin 4 insert into temp_table values( class_seq.nextval,'ddfdfdf'); 5 end class_trigger2; 6 /警告:已创建的触发程序出现编译错误。
执行 show error; 查看错误信息,贴出来看看
create or replace trigger class_trigger after insert on class begin insert into temp_class values( class_seq.nextval,'ddfdfdf'); end class_trigger;把表名修改为temp_class;
(Cno int,
Cch varchar2(500));SQL> create or replace trigger class_trigger2
2 after insert on class2
3 begin
4 insert into temp_table values( class_seq.nextval,'ddfdfdf');
5 end class_trigger2;
6 /警告:已创建的触发程序出现编译错误。
show error;
查看错误信息,贴出来看看
after insert on class
begin
insert into temp_class values( class_seq.nextval,'ddfdfdf');
end class_trigger;把表名修改为temp_class;