6.25 SDO_NET.DELETE_FEATURE_ELEMENTS

Format

SDO_NET.DELETE_FEATURE_ELEMENTS(
     feature_layer_id IN NUMBER,
     feature_id       IN NUMBER,
     feature_elements IN SDO_NET_FEAT_ELEM_ARRAY,
     delete_net_elems IN BOOLEAN DEFAULT FALSE);

Description

Deletes feature elements from a feature.

Parameters

feature_layer_id

ID of the feature layer containing the feature.

feature_id

ID of the feature from which to delete the feature elements.

feature_elements

Feature elements to be deleted. (The SDO_NET_FEAT_ELEM_ARRAY type is described in Data Types Used for Feature Modeling.)

delete_net_elems

Controls whether all network elements that are referenced only by the specified features are also deleted: TRUE also deletes such elements; FALSE (the default) does not also delete such elements.

Usage Notes

Contrast this procedure with SDO_NET.DELETE_FEATURE_ELEMENTS_AT.

Examples

The following example two point feature elements from a specified feature layer.

DECLARE
  feature_layer_id NUMBER;
  feature_id NUMBER := 1;
  elements SDO_NET_FEAT_ELEM_ARRAY := SDO_NET_FEAT_ELEM_ARRAY();
  link_id NUMBER := 1314;
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  elements.extend;
  elements(1) := SDO_NET_FEAT_ELEM(SDO_NET.FEAT_ELEM_TYPE_POL, link_id, 0.2, null);
  elements.extend;
  elements(2) := SDO_NET_FEAT_ELEM(SDO_NET.FEAT_ELEM_TYPE_POL, link_id, 0.7, null);
  sdo_net.delete_feature_elements(feature_layer_id, feature_id, elements);
END;
/