ORA-01008: not all variables have been bound problems, solution.

The version of the database is 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 ;
/

Started by Elijah at November 24, 2016 - 6:32 PM

CREATE OR UPDATE TRIGGER trig_del_tb_test
BEFORE DELETE
ON tb_test

Instead of

CREATE OR replace TRIGGER trig_del_tb_test
BEFORE DELETE
ON tb_test

Posted by Zoey at November 29, 2016 - 7:18 PM

Trigger operating inside the same table...... The need to be cautious

Posted by Caspar at December 05, 2016 - 7:54 PM

That is the question, thank you very much.

Posted by Elijah at December 18, 2016 - 8:38 PM