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

Last updated on FEBRUARY 08, 2017

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

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