PL/SQL (MOSC)

MOSC Banner

00060. 00000 - "deadlock detected while waiting for resource"

edited May 18, 2016 3:11AM in PL/SQL (MOSC) 9 commentsAnswered ✓

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center