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).
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; /
Parent topic: SDO_NET Package Subprograms