create or replace trigger "HUAQING"."TEST_FLX"
before INSERT ON "HUAQING"."T_CMPP_RECEIVE"
FOR EACH ROW
declare
-- local variables here
begin
update t_cmpp_receive set id=101 where Process_Flag=0;
end test_flx;
/
before INSERT ON "HUAQING"."T_CMPP_RECEIVE"
FOR EACH ROW
declare
-- local variables here
begin
update t_cmpp_receive set id=101 where Process_Flag=0;
end test_flx;
/
before INSERT ON "HUAQING"."T_CMPP_RECEIVE "
FOR EACH ROW
declare
-- local variables here
begin
:new.id:=seq_name.nextval;
end test_flx;
/
Line: 6
Text: :new.id:=FENGLX.Nextval;Error: PL/SQL: Statement ignored
Line: 6
Text: :new.id:=FENGLX.Nextval;
我用建表用户建立trigger,而且建表用户付了dba权限
错误还是
在此上下文中不允许表,视图或序列引用 'FENGLX.NEXTVAL'to飘
after改为befor,程序能够执行但是,id号没有更新。