6.105 SDO_NET.VALIDATE_NETWORK
Format
SDO_NET.VALIDATE_NETWORK( network IN VARCHAR2, check_data IN VARCHAR2 DEFAULT 'FALSE' ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the network is valid; returns the string FALSE
if the network is not valid.
Parameters
Usage Notes
This function checks the metadata for the network and any applicable network schema structures (link, node, path, subpath, LRS). It performs basic referential integrity checks on the network data, and it optionally performs additional checks. If any errors are found, the function returns the string FALSE
.
The checks performed by this function include the following:
-
The network exists.
-
The node and link tables for the network exist, and they contain the required columns.
-
The start and end nodes of each link exist in the node table.
-
For an LRS geometry network, the LRS table exists and contains the required columns.
-
For a spatial network, columns for the node and path geometries exist and have spatial indexes defined on them.
-
If
check_data
isTRUE
, additional referential integrity checking on the network data is performed. This will take longer, especially if the network is large.
Examples
The following example validates the network named LOG_NET1
.
SELECT SDO_NET.VALIDATE_NETWORK('LOG_NET1') FROM DUAL; SDO_NET.VALIDATE_NETWORK('LOG_NET1') -------------------------------------------------------------------------------- TRUE
Parent topic: SDO_NET Package Subprograms