那是你不会用: SQL> create table test(aaa number);表已创建。SQL> create or replace trigger tr_modify 2 before insert on test 3 for each row 4 begin 5 :new.aaa:=100; 6 end; 7 /触发器已创建SQL> insert into test values(1);已创建 1 行。SQL> select * from test; AAA ---------- 100SQL>
我把我代码发你看看 cc :=‘123544’; IF CC IS NOT NULL THEN :NEW.COL_NUMBER := CC; END IF; 编译就报错ora-04084:无法更改此触发器类型的new值
SQL> create table test(aaa number);表已创建。SQL> create or replace trigger tr_modify
2 before insert on test
3 for each row
4 begin
5 :new.aaa:=100;
6 end;
7 /触发器已创建SQL> insert into test values(1);已创建 1 行。SQL> select * from test; AAA
----------
100SQL>
cc :=‘123544’;
IF CC IS NOT NULL THEN
:NEW.COL_NUMBER := CC;
END IF;
编译就报错ora-04084:无法更改此触发器类型的new值