cn_hierarchy_edges_t5
BEFORE UPDATE ON CN_HIERARCHY_EDGES_ALL
REFERENCING NEW as new
OLD as old
FOR EACH ROW
Type
BEFORE EACH ROW
Event
UPDATE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
IF ( :old.value_id <> :new.value_id ) THEN
UPDATE cn_hierarchy_nodes
SET ref_count = nvl(ref_count, 0) - 1
WHERE value_id = :old.value_id
AND dim_hierarchy_id = :old.dim_hierarchy_id;
UPDATE cn_hierarchy_nodes
SET ref_count = nvl(ref_count, 0) + 1
WHERE value_id = :new.value_id
AND dim_hierarchy_id = :new.dim_hierarchy_id;
END IF;
END;