My Oracle Support Banner

GetVertices() Returns Only One Record For Oriented Points on Oracle 19c (Doc ID 2745717.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

-------------------------------
-- In Oracle 19 ---------------
-------------------------------

-- The query
select MDSYS.SDO_UTIL.GETVERTICES(
MDSYS.SDO_GEOMETRY(3001, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1, 1, 4, 1, 0), MDSYS.SDO_ORDINATE_ARRAY(1419611.43609412, 4193195.40499696, 0, -0.937750349512884, 0.34731006606268, 0))
) from dual;

-- The result
MDSYS.VERTEX_TYPE(1419611.43609412, 4193195.40499696, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1)

While on Oracle 12c:

-------------------------------
-- In Oracle 12 ---------------
-------------------------------

-- The query
select MDSYS.SDO_UTIL.GETVERTICES(
MDSYS.SDO_GEOMETRY(3001, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1, 1, 4, 1, 0), MDSYS.SDO_ORDINATE_ARRAY(1419611.43609412, 4193195.40499696, 0, -0.937750349512884, 0.34731006606268, 0))
) from dual;

-- The result
MDSYS.VERTEX_TYPE(1419611.43609412, 4193195.40499696, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1)
MDSYS.VERTEX_TYPE(-0.937750349512884, 0.34731006606268, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2)

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.