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

feature_layer_id

ID of the feature layer for the feature (that is, the child feature).

feature_id

ID of the feature.

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;
/