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 FEBRUARY 08, 2017

Applies to:

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

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

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