ORA-01008: 并非所有变量都已绑定的问题，求解。

[家乡的苹果]

数据库版本是 11.2.0.3.0

CREATE OR UPDATE TRIGGER trig_del_tb_test
BEFORE DELETE
ON tb_test
--REFERENCING OLD AS old_value NEW AS new_value
FOR EACH ROW

BEGIN

INSERT INTO tb_test(user_id , user_name )
VALUES(:old.user_id,:old.user_name );

END ;
/

[无敌小二傻]

CREATE OR UPDATE TRIGGER trig_del_tb_test BEFORE DELETE ON tb_test 改为 CREATE OR replace TRIGGER trig_del_tb_test BEFORE DELETE ON tb_test

[wumugulu]

trigger里面操作同一张表。。。。。。需谨慎

[家乡的苹果]

引用 楼主 mm_88 的回复:

数据库版本是 11.2.0.3.0 CREATE OR UPDATE TRIGGER trig_del_tb_test BEFORE DELETE ON tb_test --REFERENCING OLD AS old_value NEW AS new_value FOR EACH ROW BEGIN INSERT INTO tb_test(user_id , user_name ) VALUES(:old.user_id,:old.user_name ); END ; /

就是这个问题，非常感谢。