6.27 SDO_NET.DELETE_FEATURES

Format

SDO_NET.DELETE_FEATURES(
     feature_layer_id IN NUMBER,
     feature_ids      IN SDO_NUMBER_ARRAY,
     delete_net_elems IN BOOLEAN DEFAULT FALSE,
     delete_children  IN BOOLEAN DEFAULT FALSE);

Description

Deletes features.

Parameters

feature_layer_id

ID of the feature layer containing the features

feature_ids

IDs of the features 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.

delete_children

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

Usage Notes

(None.)

Examples

The following example deletes the feature with feature ID 1 from the POI feature layer in the GRID network.

DECLARE
  feature_layer_id NUMBER;
  feature_ids SDO_NUMBER_ARRAY := SDO_NUMBER_ARRAY(1);
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  sdo_net.delete_features(feature_layer_id, feature_ids, false, false);
END;
/