6.5 SDO_NET.ADD_FEATURE_ELEMENTS

Format

SDO_NET.ADD_FEATURE_ELEMENTS(
     feature_layer_id IN NUMBER,
     feature_id       IN NUMBER,
     feature_elements IN SDO_NET_FEAT_ELEM,_ARRAY,
     check_integrity  IN BOOLEAN DEFAULT TRUE);

Description

Adds an array of feature elements to a feature.

Parameters

feature_layer_id

ID of the feature layer for the feature.

feature_id

ID of the feature.

feature_elements

Feature elements to be added to the feature. These feature elements are automatically appended to the end of any existing feature elements in the feature. (The SDO_NET_FEAT_ELEM_ARRAY type is described in Data Types Used for Feature Modeling.)

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 a single feature element to a feature, use the SDO_NET.ADD_FEATURE_ELEMENT procedure.

Examples

The following example adds two point feature elements at the end of the feature elements associated with feature ID 1.

DECLARE
  feature_layer_id NUMBER;
  feature_id NUMBER := 1;
  elements SDO_NET_FEAT_ELEM_ARRAY := SDO_NET_FEAT_ELEM_ARRAY();
  link_id NUMBER := 1314;
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  elements.extend;
  elements(1) := SDO_NET_FEAT_ELEM(SDO_NET.FEAT_ELEM_TYPE_POL, link_id, 0.7, null);
  elements.extend;
  elements(2) := SDO_NET_FEAT_ELEM(SDO_NET.FEAT_ELEM_TYPE_POL, link_id, 0.8, null);
  sdo_net.add_feature_elements(feature_layer_id, feature_id, elements);
END;
/