6.47 SDO_NET.GET_FEATURE_LAYER_ID

Format

SDO_NET.GET_FEATURE_LAYER_ID(
     network_name       IN VARCHAR2
     feature_layer_name IN VARCHAR2
) RETURN NUMBER;

Description

Returns the feature layer ID for a specified feature layer.

Parameters

network_name

Network name.

feature_layer_name

Feature layer name.

Usage Notes

This function returns the value of the FEATURE_LAYER_ID column for the network and feature layer combination in the USER_SDO_NETWORK_FEATURE view (see Table 5-41 in xxx_SDO_NETWORK_FEATURE Views).

Examples

The following example gets and displays the feature layer ID for a specified feature layer.

DECLARE
  feature_layer_id NUMBER;
BEGIN
  feature_layer_id := sdo_net.get_feature_layer_id('GRID', 'POI');
  dbms_output.put_line('Feature layer ID for the POI feature layer is '||feature_layer_id);
END;
/