6.43 SDO_NET.GET_DANGLING_FEATURES

Format

SDO_NET.GET_DANGLING_FEATURES(
     feature_layer_id IN NUMBER
) RETURN SDO_NUMBER_ARRAY;

Description

Returns the IDs of dangling features in a feature layer. A dangling feature is a feature that is not associated with any network elements (nodes or links).

Parameters

feature_layer_id

ID of the feature layer containing the features.

Usage Notes

To delete the dangling features in a feature layer, use the SDO_NET.DELETE_DANGLING_FEATURES procedure.

Examples

The following example gets the dangling features in the POI feature layer of the GRID network and then displays their feature IDs.

DECLARE
  feature_layer_id NUMBER;
  feature_ids SDO_NUMBER_ARRAY;
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  feature_ids := sdo_net.get_dangling_features(feature_layer_id);
  dbms_output.put_line('Dangling Features:');
  for i in 1..feature_ids.count loop
    dbms_output.put_line('['||i||'] '||feature_ids(i));
  end loop;
END;
/