6.4 SDO_NET.ADD_FEATURE_ELEMENT
Format
SDO_NET.ADD_FEATURE_ELEMENT( feature_layer_id IN NUMBER, feature_id IN NUMBER, feature_element IN SDO_NET_FEAT_ELEM, sequence_number IN NUMBER DEFAULT NULL, check_integrity IN BOOLEAN DEFAULT TRUE);
Description
Adds a feature element to a feature.
Parameters
- feature_layer_id
-
ID of the feature layer for the feature.
- feature_id
-
ID of the feature.
- feature_element
-
Feature element to be added to the feature. This feature element is automatically appended to the end of any existing feature elements in the feature. (The SDO_NET_FEAT_ELEM type is described in Data Types Used for Feature Modeling.)
- sequence_number
-
Sequence number of the added feature element in the feature. If this parameter is null, a sequence number after the last current number is assigned.
- check_integrity
-
TRUE
(the default) checks if the input network elements exist; and if any do not exist, an error is generated.FALSE
does not check if the input network elements exist.
Usage Notes
To add multiple feature elements to a feature in a single operation, use the SDO_NET.ADD_FEATURE_ELEMENTS procedure.
To update a feature element, use the SDO_NET.UPDATE_FEATURE_ELEMENT procedure.
Examples
The following example adds a point feature for node ID 13 at sequence number 2.
DECLARE feature_layer_id NUMBER; feature_id NUMBER := 1; feature_element SDO_NET_FEAT_ELEM; node_id NUMBER := 13; BEGIN feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI'); feature_element := SDO_NET_FEAT_ELEM(SDO_NET.FEAT_ELEM_TYPE_PON, node_id, null, null); sdo_net.add_feature_element(feature_layer_id, feature_id, feature_element, 2); END; /
Parent topic: SDO_NET Package Subprograms