6.77 SDO_NET.GET_PARENT_FEATURE_IDS
Format
SDO_NET.GET_PARENT_FEATURE_IDS( feature_layer_id IN NUMBER, feature_id IN NUMBER ) RETURN SDO_NET_LAYER_FEAT_ARRAY;
Description
Returns the feature layer ID and parent feature IDs for the specified feature. (The SDO_NET_LAYER_FEAT_ARRAY type is described in Data Types Used for Feature Modeling.)
Parameters
Usage Notes
To get the feature layer ID and feature ID of the child features for a specified feature, use the SDO_NET.GET_CHILD_FEATURE_IDS function.
For information about features, including parent and child features, see Features and Feature Layers.
Examples
The following example returns and displays the parent feature IDs for feature 1 in the POI
feature layer.
DECLARE feature_layer_id NUMBER; feature_id NUMBER := 1; feature_ids SDO_NET_LAYER_FEAT_ARRAY; BEGIN feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI'); feature_ids := sdo_net.get_parent_feature_ids(feature_layer_id, feature_id); FOR i in 1..feature_ids.count LOOP --dbms_output.put_line('['||i||']'||' FEATURE_LAYER_ID = '||feature_ids(i).feature_layer_id); dbms_output.put_line('['||i||']'||' FEATURE_ID = '||feature_ids(i).feature_id); dbms_output.put_line('---'); END LOOP; END; /
Parent topic: SDO_NET Package Subprograms