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