00060. 00000 - "deadlock detected while waiting for resource"
I have wrote the following triggers.. requirement is.. if any user delete any entry from mytable1 then delete trigger activate and copy same row into mytable2 and then insert trigger activate and copy the same row into mytable1.
mytable1 has primary key.. i think due to that reason, its showing the error. "deadlock detected while waiting for resource"
CREATE OR REPLACE TRIGGER qrtz_after_delete AFTER
DELETE ON mytable1 FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT
INTO mytable2
(
TRIGGER_NAME,
TRIGGER_GROUP,
JOB_NAME,
JOB_GROUP,
IS_VOLATILE,
DESCRIPTION,
NEXT_FIRE_TIME,
PREV_FIRE_TIME,
PRIORITY,
TRIGGER_STATE,