TRIGGER: MDSYS.SDO_NETWORK_CONS_UPD_TRIG

Source

Description

sdo_network_cons_upd_trig
INSTEAD OF UPDATE ON user_sdo_network_constraints
REFERENCING OLD AS o NEW AS n
FOR EACH ROW

Type

INSTEAD OF

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS N OLD AS O

Body

DECLARE
  user_name    VARCHAR2(256);
BEGIN

  EXECUTE IMMEDIATE 'SELECT USER FROM DUAL' INTO user_name;

  UPDATE sdo_network_constraints
    SET
            (constraint,
       description,
       class_name,
       class)
      =
            (SELECT
               :n.constraint,
         :n.description,
         :n.class_name,
         :n.class
       FROM DUAL)
    WHERE  NLS_UPPER(sdo_owner)  = NLS_UPPER(user_name)
      AND  constraint = :o.constraint;
END;