Can we do this: Populate a variable inside a trigger?

From: Johan Muller <johan.muller_at_gmail.com>
Date: Fri, 1 Sep 2006 15:08:53 -0500
Message-ID: <3b9442840609011308j3728e0b0s47439d1322995a6@mail.gmail.com>

CREATE OR REPLACE TRIGGER features_tbl_au AFTER UPDATE ON features_tbl REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE     v_file VARCHAR2(1024);
BEGIN
    IF (:NEW.enabled = 1 AND :OLD.enabled = 0) THEN

        v_file := '/vobs/NMS/nms/sql/nms_security/' || :NEW.name;
        @@v_file;

    END IF;
EXCEPTION
    WHEN DUP_VAL_ON_INDEX THEN
        NULL; -- script has already been run so just ignore this type of error

    WHEN OTHERS THEN
        RAISE;
END;
/

SP2-0310: unable to open file "v_file.sql"

Is there a way to execute the script - the trigger will not pass the v_file variable to complete :NEW.name variable.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 01 2006 - 15:08:53 CDT