6.102 SDO_NET.UPDATE_FEATURE_ELEMENT

Format

SDO_NET.UPDATE_FEATURE_ELEMENT(      
  feature_layer_id IN NUMBER,      
  feature_id       IN NUMBER,      
  sequence_number  IN NUMBER,      
  feature_element  IN SDO_NET_FEAT_ELEM,      
  check_integrity  IN BOOLEAN DEFAULT TRUE);

Description

Updates a feature element.

Parameters

feature_layer_id

ID of the feature layer for the feature.

feature_id

ID of the feature.

sequence_number

Sequence number of the feature element to be updated.

feature_element

Feature element definition to replace the specified feature element. (The SDO_NET_FEAT_ELEM 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 feature element, 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 updates the feature element at sequence number 2 on link ID 1314 of feature ID 1.

DECLARE
  feature_layer_id NUMBER;
  feature_id NUMBER := 1;
  element SDO_NET_FEAT_ELEM;
  link_id NUMBER := 1314;
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  element := SDO_NET_FEAT_ELEM(SDO_NET.FEAT_ELEM_TYPE_POL, link_id, 0.2, null);
  sdo_net.update_feature_element(feature_layer_id, feature_id, 1, element);
END;
/