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