How can I run a Rigger that automatically updates a table when an attribute is updated?

Question

Create OR Replace TRIGGER filme_log
before Update OF custo On filme
Referencing New As New Old As Old
For Each Row 
Begin 
Insert into filme_log Values(:new.nome_original, :old.custo, :new.custo, sysdate);
END;

This is my Rigger and this is working.

Begin
Update filme set custo = 9876546 where nome_original = 'UP';
Commit;
Declare
Cursor filme_log_cur is
Select nomeF,custo_old,custo_new, data
From filme_log;
nomeF_cur filme_log.nomeF%type;
custo_old_cur filme_log.custo_old%type;
custo_new_cur filme_log.custo_new%type;
data_cur filme_log.data%type;
Begin
Open filme_log_cur;
Loop Fetch filme_log_cur into nomeF_cur, custo_old_cur, custo_new_cur, data_cur;
EXIT WHEN filme_log_cur%notfound;
DBMS_Output.put_line('Dados inseridos em Filme_log:');
DBMS_Output.put_line(nomeF_cur || '  ' ||custo_old_cur || '  ' ||custo_new_cur || '  ' || data_cur);
END LOOP;
END;

And I’m trying to run this Rigger but I can’t understand why it’s not working.

Answer 1

The problem may be that Trigger is disabled.

First check that Trigger is enabled using:

SELECT STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'filme_log';

If disabled, enable using:

ALTER TRIGGER filme_log ENABLE;