6.20 SDO_NET.DELETE_CHILD_FEATURES
Format
SDO_NET.DELETE_CHILD_FEATURES( parent_layer_id IN NUMBER, parent_feature_id IN NUMBER, child_feature_ids IN SDO_NET_LAYER_FEAT_ARRAY);
Description
Removes the parent-child relationship for the input child features.
Parameters
- parent_layer_id
-
ID of the parent feature layer.
- parent_feature_id
-
ID of the parent feature of the specified child features.
- child_feature_ids
-
IDs of the child features. (The SDO_NET_LAYER_FEAT_ARRAY type is described in Data Types Used for Feature Modeling.)
Usage Notes
The specified parent and child features must exist.
To delete the child features at specified sequence points, use the SDO_NET.DELETE_CHILD_FEATURES_AT procedure.
Examples
The following example deletes a child feature with feature ID 1 in the POI
feature layer.
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, 1); sdo_net.delete_child_features(parent_layer_id, parent_feature_id, child_feature_ids); END; /
Parent topic: SDO_NET Package Subprograms