How to create trigger to log inserts/updates on table?
as our client 'plays' always with the parameters in the database, we'ld like to have a logging of what they did. The easiest way for me seems a trigger, but I always get the erro ORA-4082: can't use old and new in table trigger.
CREATE OR REPLACE TRIGGER OMS.configdicttrig
AFTER INSERT OR UPDATE
insert into configdict_log
values (ld.CATEGORY ,