6.2 SDO_NET.ADD_CHILD_FEATURES

Format

SDO_NET.ADD_CHILD_FEATURES(
     parent_layer_id   IN NUMBER,
     parent_feature_id IN NUMBER,
     child_feature_ids IN SDO_NET_LAYER_FEAT_ARRAY,
     check_integrity   IN BOOLEAN DEFAULT TRUE);

Description

Associates multiple features as child features of a specified parent feature.

Parameters

parent_layer_id

ID of the parent feature layer.

parent_feature_id

ID of the feature that is to become the parent feature of the specified child features.

child_feature_ids

IDs of features to be associated as child features of the specified parent feature. (The SDO_NET_LAYER_FEAT_ARRAY type is described in Data Types Used for Feature Modeling.)

check_integrity

TRUE (the default) checks if the child features exist; and if any do not exist, an error is generated. FALSE does not check if the child features exist.

Usage Notes

The specified child features must already exist.

To associate a single feature as a child feature, use the SDO_NET.ADD_CHILD_FEATURE procedure.

Examples

The following example adds two child features at the end of the parent feature.

DECLARE
  parent_layer_id NUMBER;
  parent_feature_id NUMBER := 1;
  child_layer_id NUMBER;
  child_feature_ids SDO_NET_LAYER_FEAT_ARRAY := SDO_NET_LAYER_FEAT_ARRAY();
BEGIN
  parent_layer_id := sdo_net.get_feature_layer_id('GRID', 'PARENT_LAYER');
  child_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  child_feature_ids.extend;
  child_feature_ids(1) := SDO_NET_LAYER_FEAT(child_layer_id, 4);
  child_feature_ids.extend;
  child_feature_ids(2) := SDO_NET_LAYER_FEAT(child_layer_id, 10);
  sdo_net.add_child_features(parent_layer_id, parent_feature_id, child_feature_ids, true);
END;
/