我得触发器如下:
create or replace trigger test_xue1
after insert or update or delete on count2
for each row
declare
old_values varchar2(400);
strsql varchar2(400);
begin
old_values :='num';
if updating('num')then
strsql:='update count2_log set tablename = :old.'||old_values||' where keyid_no=6';
dbms_output.put_line(strsql);
execute immediate strsql;
end if;
end;
此段代码编译得时候是正确得,但是当我做update操作:update count2 set num=8 where keyid=6;
报错ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], []
ORA-06512: at "TEST.TEST_XUE1", line 10
ORA-04088: error during execution of trigger 'TEST.TEST_XUE1'
create or replace trigger test_xue1
after insert or update or delete on count2
for each row
declare
old_values varchar2(400);
strsql varchar2(400);
begin
old_values :='num';
if updating('num')then
strsql:='update count2_log set tablename = :old.'||old_values||' where keyid_no=6';
dbms_output.put_line(strsql);
execute immediate strsql;
end if;
end;
此段代码编译得时候是正确得,但是当我做update操作:update count2 set num=8 where keyid=6;
报错ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], []
ORA-06512: at "TEST.TEST_XUE1", line 10
ORA-04088: error during execution of trigger 'TEST.TEST_XUE1'
感觉上是这个意思