My Oracle Support Banner

Sdo_cs.make_2d Creates Not Null Geometry From Null Geometry (Doc ID 1533951.1)

Last updated on FEBRUARY 07, 2019

Applies to:

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

Symptoms

Converting 3D geometries to 2D geometries 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)

A workaround can be employed by adding this WHERE clause:

  WHERE geom_column not NULL;

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

Changes

 

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


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