proc_inst表执行insert行级触发的时候成了变异表,此时不能操作.
create or replace trigger trig_name
before insert proc_inst
for each row
begin
select 'test' into :new.auth_name from dual;
end ;
create or replace trigger trig_name
before insert proc_inst
for each row
begin
select 'test' into :new.auth_name from dual;
end ;
Action Rewrite the trigger (or function) so it does not read that table.
select user_name into username from exmainframe.SYS_USER where user_code = :new.ENTR_SEND;而此语句会出错:
select user_name into username from exmainframe.SYS_USER where user_code = :new.ENTR_RECI;
触发器如下:CREATE OR REPLACE TRIGGER "EXFLOW".
"TRG_RECI_ENTR_UPDATEUSERNAME" BEFORE INSERT
ON "RECI_ENTR"
FOR EACH ROW
declare username varchar2(50);
begin
select user_name into username from exmainframe.SYS_USER where user_code = :new.ENTR_SEND;
select username into :new.SEND_NAME from dual;
select user_name into username from exmainframe.SYS_USER where user_code = :new.ENTR_RECI;
select username into :new.RECI_NAME from dual;
end;