Trigger Mutating solved now deadlock error [message #398708] |
Fri, 17 April 2009 03:53  |
rakeshramm
Messages: 175 Registered: September 2006 Location: Oracle4u.com
|
Senior Member |

|
|
i want to update a field D_UPDTDATE of table TEST if it is updated how to write a trigger ;when i wrote a trigger its giving mutating trigger error to solve i used
PRAGMA AUTONOMOUS TRANSACTION but now error is regarding deadlock
CREATE TABLE test
(
N_JOBID NUMBER(10),
N_APRVBYID NUMBER(5),
D_APPRVDATE DATE,
D_ENTRYDAT DATE DEFAULT sysdate,
D_UPDTDATE DATE
)
CREATE OR REPLACE TRIGGER trg_test
after update ON test for each row
declare
PRAGMA AUTONOMOUS_TRANSACTION;
begin
update test set D_UPDTDATE=sysdate ;
commit;
end trigger;
How to solve this .Please Help me Thanks in Advance
|
|
|
|
|
|