6.44 SDO_NET.GET_DANGLING_LINKS

Format

SDO_NET.GET_DANGLING_LINKS(
     network IN VARCHAR2
) RETURN SDO_NUMBER_ARRAY;

Description

Returns links that are not referenced by any feature in any feature layer.

Parameters

network

Name of the network.

Usage Notes

To delete the dangling links in a network, use the SDO_NET.DELETE_DANGLING_LINKS procedure.

Examples

The following example gets the dangling links in the GRID network and then displays the number (count) of dangling links found.

DECLARE
  link_ids SDO_NUMBER_ARRAY;
BEGIN
  link_ids := sdo_net.get_dangling_links('GRID');
  dbms_output.put_line('Number of dangling Links: '||link_ids.count);
END;
/