6.106 SDO_NET.VALIDATE_NODE_SCHEMA
Format
SDO_NET.VALIDATE_NODE_SCHEMA( network IN VARCHAR2 ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the metadata relating to nodes in a network is valid; returns the string FALSE
if the metadata relating to nodes in a network is not valid.
Usage Notes
This function checks the following for validity: table name, geometry column, and cost column for spatial networks; measure-related information for LRS networks; topology-related information for topology networks; and hierarchy-related information for hierarchical networks.
Examples
The following example checks the validity of the metadata related to nodes in the network named LOG_NET1
.
SELECT SDO_NET.VALIDATE_NODE_SCHEMA('LOG_NET1') FROM DUAL; SDO_NET.VALIDATE_NODE_SCHEMA('LOG_NET1') -------------------------------------------------------------------------------- TRUE
Parent topic: SDO_NET Package Subprograms