My Oracle Support Banner

Wrong Result In Spatial Query Using SDO_FILTER (Doc ID 2558987.1)

Last updated on APRIL 17, 2023

Applies to:

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


A query using SDO_FILTER is returning an incorrect result.  After the spatial index on the queried table is rebuilt, the correct result is returned.

The problem occurs when geometries in the table are set to NULL, then set to a geometry in the same transaction. 


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

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