My Oracle Support Banner

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

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

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