6.101 SDO_NET.UPDATE_FEATURE

Format

SDO_NET.UPDATE_FEATURE(      
  feature_layer_id   IN NUMBER,      
  feature_id         IN NUMBER,      
  feature_elements   IN SDO_NET_FEAT_ELEM_ARRAY DEFAULT NULL,      
  child_feature_ids  IN SDO_NET_LAYER_FEAT_ARRAY DEFAULT NULL,      
  check_integrity    IN BOOLEAN DEFAULT TRUE);

Description

Updates a feature in a feature layer.

Parameters

feature_layer_id

ID of the feature layer to which to update the feature.

feature_id

ID of the feature to be updated.

feature_elements

Feature elements of the feature to add to any existing feature elements. If this parameter is null, the existing feature elements are not changed. If this parameter in empty, any existing feature elements are removed. (The SDO_NET_FEAT_ELEM_ARRAY type is described in Data Types Used for Feature Modeling.)

child_feature_ids

Child features of the feature that are to add to any existing child features. If this parameter is null, the existing child features are not changed. If this parameter in empty, any existing parent relationships for this feature with child features are removed. (The SDO_NET_LAYER_FEAT_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 feature to a feature layer, use the SDO_NET.ADD_FEATURE procedure.

A feature layer ID is automatically generated for the feature layer.

Examples

The following example updates a specified feature by defining two feature elements and adding them.

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.update_feature(feature_layer_id, feature_id, elements, null);
END;
/