Spatial Topology Calls Get Error ORA-01436: CONNECT BY loop in user data (Doc ID 1666196.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Below errors appear with the Topology calls get_geometry and get_topo_elements

select a.topogeom.get_topo_elements() from ouroboros10 a;
--ORA-01436: CONNECT BY loop in user data
--ORA-06512: at "MDSYS.SDO_TOPO_GEOMETRY", line 1289

--
--
--TEST 1 repeat with get_geometry. Line numbers of the error are different
--
--
select a.topogeom.get_geometry() from ouroboros10 a;
--ORA-01436: CONNECT BY loop in user data
--ORA-06512: at "MDSYS.SDO_TOPO_GEOMETRY", line 1059

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms