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;
/