SDO_LRS.VALIDATE_LRS_GEOMETRY Erroneously Returns TRUE (Doc ID 1210212.1)

Last updated on OCTOBER 26, 2010

Applies to:

Oracle Spatial - Version: 10.2.0.4 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms


SDO_LRS.VALIDATE_LRS_GEOMETRY erroneously returns TRUE if the geometry is a multi-linestring where the linestring elements begin or end with a NULL measure.

SELECT sdo_lrs.validate_lrs_geometry
             (SDO_GEOMETRY
                (3306,
                 NULL,
                 NULL,
                 SDO_ELEM_INFO_ARRAY (1,2,1, 7,2,1),
                 SDO_ORDINATE_ARRAY (0,0,31857, 1,1,NULL, 2,2,NULL, 3,3,94167)))
      FROM dual;

SDO_LRS.VALIDATE_LRS_GEOMETRY(SDO_GEOMETRY(3306,NULL,NULL,SDO_ELEM_INFO_ARRAY(1,2,1,7,2,1),SDO_ORDIN
----------------------------------------------------------------------------------------------------
TRUE


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