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.
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.
(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.
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