Cause: A trigger (or a user defined PL/SQL function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it.
调试欢乐多
更改为
:new.xtrq=sysdate ;
2/10 PLS-00103: 出现符号 "="在需要下列之一时:
:=.(@%;indicator
符号 ":=在 "=" 继续之前已插入。
如果利用:new.xtrq:=sysdate;则发生错误
ERROR 位于第 1 行:
ORA-04084: 无法更改此触发器类型的 NEW 值
create or replace trigger tri_insxtrq
after insert on wzywzsj
for each row
begin
update wzywzsj set :new.xtrq=sysdate;
end;则错误:
2/20 PLS-00103: 出现符号 ""在需要下列之一时:
(<an identifier>
<a double-quoted delimited-identifier>
符号 "<an identifier>在 "" 继续之前已插入。