6.21 SDO_NET.DELETE_CHILD_FEATURES_AT
Format
SDO_NET.DELETE_CHILD_FEATURES_AT( parent_layer_id IN NUMBER, parent_feature_id IN NUMBER, sequence_numbers IN SDO_NUMBER_ARRAY);
Description
Removes the parent-child relationship for the child features at the specified sequence numbers.
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 child features specified by their ID values, use the SDO_NET.DELETE_CHILD_FEATURES procedure.
Examples
The following example deletes a child feature at sequence number 1.
DECLARE parent_layer_id NUMBER; parent_feature_id NUMBER := 1; sequence_numbers SDO_NUMBER_ARRAY := SDO_NUMBER_ARRAY(1); BEGIN parent_layer_id := sdo_net.get_feature_layer_id('GRID', 'PARENT_LAYER'); sdo_net.delete_child_features_at(parent_layer_id, parent_feature_id, sequence_numbers); END; /
Parent topic: SDO_NET Package Subprograms