NIM046027 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM046027
Submitted	June 12, 2009
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	9.3.1
Version Fixed	9.4
Status	Fixed

Description

When using ArcMAP's identify command with a spatial view referencing a point feature class stored as st_geometry, the following error message is returned:

"Nothing found".

Cause

The SQL statement used to query spatial views is missing commas that separate the selected attributes in the select list. The query fails with an underlying DBMS error, ORA-00923, that is not being reported to the end user in ArcMap.

Workaround

When using the Identify command, add the feature class that the spatial view references to ArcMap. The identify command returns the correct results when working with the underlying point feature class, as well as when using line and polygon feature classes.

This issue is limited to point feature classes in a spatial view that reference a feature class with its geometry storage as st_geometry. Feature classes stored with SDEBINARY or SDO_GEOMETRY work correctly.