6.40 SDO_NET.GET_CHILD_FEATURE_IDS

Format

SDO_NET.GET_CHILD_FEATURE_IDS(
     feature_layer_id IN NUMBER,
     feature_id       IN NUMBER
) RETURN SDO_NET_LAYER_FEAT_ARRAY;

Description

Returns the feature layer ID and child 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 parent feature).

feature_id

ID of the feature.

Usage Notes

To get the feature layer ID and feature ID of the parent features for a specified feature, use the SDO_NET.GET_PARENT_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 child feature IDs for feature 1 in the PARENT_LAYER 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', 'PARENT_LAYER');
  feature_ids := sdo_net.get_child_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;
/