6.29 SDO_NET.DELETE_NODE

Format

SDO_NET.DELETE_NODE(
     network IN VARCHAR2,
     node_id IN NUMBER);

Description

Deletes a node, along with all dependent network elements and all references to the node from features.

Parameters

network

Network name.

node_id

ID of the node to delete.

Usage Notes

This procedure deletes the specified node from the node table (described in Node Table), and it deletes any other network elements that depend on this node. For example, if the specified node is included in any link definitions, those links are deleted; and if any of the deleted links are included in any paths and subpaths, those paths and subpaths are deleted also.

Examples

The following example deletes the node in the SDO_NET2 network whose node ID is 1.

SELECT SDO_NET.DELETE_NODE('SDO_NET2', 1);