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