6.48 SDO_NET.GET_FEATURES_ON_LINKS

Format

SDO_NET.GET_FEATURES_ON_LINKS
     feature_layer_id IN NUMBER,
     link_ids         IN SDO_NUMBER_ARRAY
) RETURN SDO_NUMBER_ARRAY;

Description

Returns the IDs of features in a feature layer that reference specified links.

Parameters

feature_layer_id

ID of the feature layer containing the features.

link_ids

IDs of the links to check for features.

Usage Notes

To find the IDs of features in a feature layer that reference specified nodes, use the SDO_NET.GET_FEATURES_ON_NODES procedure.

Examples

The following example gets and displays the feature IDs of features on a specified link.

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