My Oracle Support Banner

ORA-1436 Querying with GET_GEOMETRY Using CONNECT BY (Doc ID 1317754.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Spatial and Graph - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

This occurs when hierarchical topology features are composed of a feature who has the same numeric value for TG_LAYER_ID,TG_ID,TOPO_ID,TOPO_TYPE in RELATION$.

In the test case, table4 is a hierarchical feature layer that points to id 3 of table 3, which is associated with a polygon primitive with topo_id 3.

select * from TRICYCLE_relation$;

TG_LAYER_ID TG_ID TOPO_ID TOPO_TYPE
----------- ---------- ---------- ----------
3 3 3 3

The connect by loop error will happen any time that the tg_layer_id/tg_id pair match the topo_id/topo_type pair, even for 0-level layers in the topology.

For example:

(TG_LAYER_ID,TG_ID,TOPO_ID,TOPO_TYPE) = (4,3,4,3)

throws the connect by loop error on get_geometry or get_topo_elements. So would any tg_layer_id with this pattern so long as the tg_id is 1,2, or 3.

Workaround: Ensure no feature is added to the topology that matches one of
the scenarios above.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.