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