Sdo_cs.make_2d Creates Not Null Geometry From Null Geometry (Doc ID 1533951.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

Converting 3D to 2D with sdo_cs.make_2d, NULL geometries become SDO_GEOMETRY(NULL, NULL, NULL, NULL, NULL)

SQL> select sdo_cs.make_2d(null) geom from dual;

GEOM(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
SDO_GEOMETRY(NULL, NULL, NULL, NULL, NULL)

Workaround using:

  WHERE geom_column not NULL;

when changing the geometries


sdo_cs.make_2d should leave NULL as NULL instead of generating the NULL GEOMETRY SDO_GEOMETRY(NULL, NULL, NULL, NULL, NULL)

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