My Oracle Support Banner

ORA-13033: Invalid Data In The SDO_ELEM_INFO_ARRAY In SDO_GEOMETRY Object (Doc ID 1556751.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

Spatial SQL select errors out with the following.

SQL> select SDO_AGGR_MBR(MYDATA.GEO) BBOX from MYDATA
  2 where (MYDATA.C01, MYDATA.C02) in
  3 (select C01, C02 from SELECTION where CTAB = 'MYDATA3');
select SDO_AGGR_MBR(MYDATA.GEO) BBOX from MYDATA
*
ERROR at line 1:
ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
ORA-06512: at "MDSYS.SDO_3GL", line 2001
ORA-06512: at "MDSYS.SDO_GEOM", line 2393
ORA-06512: at "MDSYS.SDO_GEOM", line 2516
ORA-06512: at "MDSYS.SDOAGGR", line 41
ORA-06512: at "MDSYS.AGGRMBR", line 14

Then add "and GEO is not null" to the select statement and runs ok, but returns incorrect results.

SQL> select SDO_AGGR_MBR(MYDATA.GEO) BBOX from MYDATA
  2 where (MYDATA.C01, MYDATA.C02) in
  3 (select C01, C02 from SELECTION where CTAB = 'MYDATA3')
  4 and geo is not null;

BBOX(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
SDO_GEOMETRY(3008, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARR
AY(0, 0, 0, 3478289.28, 5553556.09, 101.63))

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.