6.49 SDO_NET.GET_FEATURES_ON_NODES

Format

SDO_NET.GET_FEATURES_ON_NODES
     feature_layer_id IN NUMBER,
     node_ids         IN SDO_NUMBER_ARRAY
) RETURN SDO_NUMBER_ARRAY;

Description

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

Parameters

feature_layer_id

ID of the feature layer containing the features.

node_ids

IDs of the nodes to check for features.

Usage Notes

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

Examples

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

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