7.20 SDO_NFE.GET_MODEL_UNDERLYING_NETWORK

Format

SDO_NFE.GET_MODEL_UNDERLYING_NETWORK(
     model_id    IN SDO_NUMBER
     ) RETURN VARCHAR2;

Description

Returns the name of the network that is associated with an NFE model.

Parameters

model_id

NFE model identifier.

Usage Notes

A network is associated with an NFE model during the creation process, either when using the SDO_NFE.CREATE_MODEL_UNDERLYING_NET for models in the SDO_NFE.FROM_SCRATCH mode, or using SDO_NFE.SET_MODEL_UNDERLYING_NETWORK for models in the SDO_NFE.OVER_EXIST_NETWORK mode.

Examples

The following example gets the underlying network associated with an existing NFE model.

SELECT SDO_NFE.get_model_underlying_network(1) FROM DUAL;