1 Reply Latest reply on Nov 20, 2013 11:51 PM by rp0428

    :old in trigger

    JWBerg51

      How do I turn off bind variable substitution in Sql Developer 3.2 when I am creating a trigger that references old and new values using the colon-old format?

      I can use set define off for sqlplus, but that doesn't work for the bind variable substitution issue in triggers

        • 1. Re: :old in trigger
          rp0428
          How do I turn off bind variable substitution in Sql Developer 3.2 when I am creating a trigger that references old and new values using the colon-old format?

          I can use set define off for sqlplus, but that doesn't work for the bind variable substitution issue in triggers

          You don't need to. Just use F5 to run the script. This works for me.

          CREATE OR REPLACE TRIGGER TRIGGER1

          BEFORE UPDATE ON DEPT

          FOR EACH ROW

          BEGIN

            IF :old.dname = 'abc' THEN :new.dname := 'def'; END IF;

          END;