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

["Johan Muller" <johan.muller@xxxxxxxxx>]

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.

• Follow-Ups:
  • Re: Can we do this: Populate a variable inside a trigger?
    • From: Bjørn Dörr Jensen

Other related posts:

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

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