6.46 SDO_NET.GET_FEATURE_ELEMENTS

Format

SDO_NET.GET_FEATURE_ELEMENTS(
     feature_layer_id IN NUMBER,
     feature_id       IN NUMBER
) RETURN SDO_NET_FEAT_ELEM_ARRAY;

Description

Returns the feature elements in a feature layer. (The SDO_NET_FEAT_ELEM_ARRAY type is described in Data Types Used for Feature Modeling.)

Parameters

feature_layer_id

ID of the feature layer for the feature.

feature_id

ID of the feature.

Usage Notes

To add a feature element to a feature, use the SDO_NET.ADD_FEATURE_ELEMENT procedure; to add multiple feature elements in a single operation, use the SDO_NET.ADD_FEATURE_ELEMENTS procedure.

Examples

The following example gets the feature layer ID for a specified feature layer, then gets and displays information about the feature elements for feature 1 in this feature layer.

DECLARE
  feature_layer_id NUMBER;
  feature_id NUMBER := 1;
  elements SDO_NET_FEAT_ELEM_ARRAY;
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  elements := sdo_net.get_feature_elements(feature_layer_id, feature_id);
  FOR i in 1..elements.count
  LOOP
    dbms_output.put_line('['||i||']'||' FEAT_ELEM_TYPE   = '||elements(i).feat_elem_type);
    dbms_output.put_line('['||i||']'||' NET_ELEM_ID      = '||elements(i).net_elem_id);
    dbms_output.put_line('['||i||']'||' START_PERCENTAGE = '||elements(i).start_percentage);
    dbms_output.put_line('['||i||']'||' END_PERCENTAGE   = '||elements(i).end_percentage);
    dbms_output.put_line('---');
  END LOOP;
END;
/