I have table TEMP AS (SNO NUMBER,
I want to create trigger on this table like whenever there is update in STATE of temp table UPDATE_DATE columns get updated.
I am trying to create trigger using PRAGMA Autonomous transaction but it is not working with this and withouht PRAGMA.
With PRAGMA I am getting error "ORA-00060: deadlock detected while waiting for resource".
Is it possible to create trigger on this table for updating columns of same table.