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

network

Network name.

check_data

TRUE performs additional checks on the referential integrity of network data; FALSE (the default) performs basic checks, but not additional checks, on the referential integrity of network data.

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 is TRUE, 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