Trigger after updating record
Hi
I am using oracle 11g. I am trying to execute a procedure inside a trigger that fires after updating a record. My trigger is as follows:
CREATE or REPLACE TRIGGER test_trigger
AFTER UPDATE OF f2 ON test
FOR EACH ROW
when (new.f2 = '00' and new.f1 = '2016' )
DECLARE
BEGIN
my_test_proc(:new.f3);
END;
and my procedure is as follows:
CREATE OR REPLACE PROCEDURE my_test_proc(
v_col_f1 in varchar2) IS
BEGIN
insert into test2 (f1)
Values(v_col_f1) ;
commit;
END;
/
Both the trigger and procedure compiles without error but when I am going to update f2 field of test table it gives following error