对表本身触发问题?

[SambaGao]

create table gjhohj_a (id int,name varchar(20),value int)

create table gjhohj_b (id int,name varchar(20),value int) 

insert into gjhohj_a values (1,
'a',12)

insert into gjhohj_b values(1,'b',12)

commit

drop trigger gjhohj
create or replace trigger gjhohj after update
on gjhohj_a for each row

begin

insert into gjhohj_a values(:OLD.id,:OLD.name,:OLD.value) ;


end ;
update gjhohj_a set id='2'

ORA-04091: table FZDC.GJHOHJ_A is mutating, trigger/function may not see it
ORA-06512: at "FZDC.GJHOHJ", line 2
ORA-04088: error during execution of trigger 'FZDC.GJHOHJ'

[suiziguo]

create or replace trigger gjhohj after update
on gjhohj_a for each row
DECLARE PRAGMA AUTONOMOUS_TRANSACTION;
begin

insert into gjhohj_a values(:OLD.id,:OLD.name,:OLD.value) ;


end ;

[wuyisky84]

又要用自治事务?

[Hemes_MC]

create or replace procedure gjhohj(
id int;
name varchar;
value int;)
is
begin
insert into gjhohj_a values(id,name,value);
commit;
end gjhohj;
/

create or replace trigger gjhohj
after update on gjhohj_a
for each row
DECLARE PRAGMA AUTONOMOUS_TRANSACTION;
begin
gjhohj(:old.id,:old.name,:old.value);
commit;
end;
/