PL/SQL (MOSC)

MOSC Banner

When can an after insert/update trigger not fire

edited May 21, 2016 5:02AM in PL/SQL (MOSC) 12 commentsAnswered

I've got this trigger

create or replace

TRIGGER "DOKCENTRA"."TR_INTDOC_AFTER" AFTER

  UPDATE or INSERT

    ON "DOKCENTRA"."AG_INT_DOC" FOR EACH ROW

  BEGIN

    IF UPDATING THEN

      IF (:NEW.DOCNUMBER IS NOT NULL AND :OLD.DOCNUMBER IS NULL) THEN

        INSERT

        INTO

          AG_DOCNUMBERS VALUES

          (

            :NEW.DOCNUMBER

          );

      END IF;

    ELSIF INSERTING THEN

      IF (:NEW.DOCNUMBER IS NOT NULL) THEN

        INSERT

        INTO

          AG_DOCNUMBERS VALUES

          (

            :NEW.DOCNUMBER

          );

      END IF;

    END IF;

  END;

Let me describe the situation first:

I've got two tables: AG_INT_DOC and AG_DOCNUMBERS . AG_INT_DOC has a column named DOCNUMBER.  This column gets its value in BEFORE INSERT/UPDATE trigger. I need to make sure that any value that is inside

Tagged:

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