6.26 SDO_NET.DELETE_FEATURE_ELEMENTS_AT

Format

SDO_NET.DELETE_FEATURE_ELEMENTS_AT(
     feature_layer_id IN NUMBER,
     feature_id       IN NUMBER,
     sequence_numbers IN SDO_NUMBER_ARRAY,
     delete_net_elems IN BOOLEAN DEFAULT FALSE);

Description

Deletes the feature elements with specified sequence numbers 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.

sequence_numbers

Array of sequence numbers for the feature elements to be deleted.

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

Examples

The following example deletes the feature element at sequence number 1.

DECLARE
  feature_layer_id NUMBER;
  feature_id NUMBER := 1;
  sequence_numbers SDO_NUMBER_ARRAY := SDO_NUMBER_ARRAY();
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  sequence_numbers.extend;
  sequence_numbers(1) := 1;
  sdo_net.delete_feature_elements_at(feature_layer_id, feature_id, sequence_numbers);
END;
/