6.82 SDO_NET.GET_PHANTOM_FEATURES

Format

SDO_NET.GET_PHANTOM_FEATURES(      
  feature_layer_id  IN NUMBER      
) RETURN SDO_NUMBER_ARRAY;

Description

Returns the IDs of phantom features in a feature layer. A phantom feature is a feature that references nonexistent network elements (nodes or links).

Parameters

feature_layer_id

ID of the feature layer containing the features.

Usage Notes

To delete the phantom features in a feature layer, use the SDO_NET.DELETE_PHANTOM_FEATURES procedure.

Examples

The following example gets and displays the feature IDs of phantom features in a specified feature layer.

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_phantom_features(feature_layer_id);
  dbms_output.put_line('Phantom Features:');
  for i in 1..feature_ids.count loop
    dbms_output.put_line('['||i||'] '||feature_ids(i));
  end loop;
END;
/