1 Reply Latest reply: Nov 20, 2013 5:51 PM by rp0428 RSS

    :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;