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