laptop and a wrench

Bug

ArcGIS 10.1 Service Pack 1 does not display the geometry using the query layer for Oracle Spatial function SDO_GEOM.SDO_MBR.

Last Published: July 31, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM092943
SubmittedJuly 6, 2013
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.1
StatusWill Not Be Addressed

Additional Information

ArcMap needs to add a spatial filter to the result of the query layer, in order to display the results based on the extent of the current map. This query fails at Oracle: select OBJECTID,SHAPE from (select OBJECTID,SDO_GEOM_MBR(c.shape) as shape from test c ) a where sdo_filter(SHAPE,MDSYS.SDO_GEOMETRY(:gtype1,:srid1,NULL,:elem_info1,:ordinates1),'querytype=window') = 'TRUE'

Steps to Reproduce

Bug ID: NIM092943

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options