6.103 SDO_NET.VALIDATE_LINK_SCHEMA
Format
SDO_NET.VALIDATE_LINK_SCHEMA( network IN VARCHAR2 ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the metadata relating to links in a network is valid; returns the string FALSE
if the metadata relating to links 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 links in the network named ROADS_NETWORK
.
SELECT SDO_NET.VALIDATE_LINK_SCHEMA('ROADS_NETWORK') FROM DUAL; SDO_NET.VALIDATE_LINK_SCHEMA('ROADS_NETWORK') -------------------------------------------------------------------------------- TRUE
Parent topic: SDO_NET Package Subprograms