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.
Edited by: user6040008 on Dec 11, 2012 1:08 AM