Spatial Query Fails with ORA-13034: Invalid Data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY Object Error (Doc ID 2040477.1)

Last updated on NOVEMBER 25, 2019

Applies to:

Symptoms

Below query works fine in Oracle 11.2.0.3 instance but errors in Oracle 11.2.0.4 onwards. See the below test results -

SQL> CREATE TABLE cola_markets (
mkt_id NUMBER PRIMARY KEY,
name VARCHAR2(32),
shape MDSYS.SDO_GEOMETRY);  

Table created.

SQL> INSERT INTO USER_SDO_GEOM_METADATA
VALUES (
'cola_markets',
'shape',
MDSYS.SDO_DIM_ARRAY( -- 20X20 grid
MDSYS.SDO_DIM_ELEMENT('X', 0, 20, 0.005),
MDSYS.SDO_DIM_ELEMENT('Y', 0, 20, 0.005)
),
8307
);  

1 row created.

SQL> CREATE INDEX cola_spatial_idx
ON cola_markets(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;  

Index created.

SQL> SELECT count(*) FROM cola_markets t1
WHERE SDO_INSIDE(t1.shape, SDO_GEOMETRY(2003, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-104.994430, 39.746745, -100.994430, 35.746745))) = 'TRUE';  
SELECT count(*) FROM cola_markets t1
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13200: internal error [ODCIIndexStart] in spatial indexing.
ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 416

Cause

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