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; /
Parent topic: SDO_NET Package Subprograms