Select to view content in your preferred language

Identify doesn't work when using views in Oracle (bug?)

6425
11
12-28-2012 01:01 AM
MortenHansen
Emerging Contributor
The Identify/info function in ArcMap (or via javascript API in a web application) doesn't work when using a View in Oracle.

Identify works fine on a simple feature class (eg. "MyFeatureClass" with an ID, a shape and a text attribute column), but when I create a simple view, eg. "SELECT * FROM MyFeatureClass", the identify function doesn't give any result, no matter where I click.

Both the feature class and the view are created via ArcCatalog in ArcMap.

The problem was identified using ArcGIS Server and the Javascript ArcGIS API, but the same problem exists using ArcMap directly on the database connection.

If I use the exact same setup, but with SQL Server instead of Oracle, the problem dissapears.

I am using ArcGIS 10.1.

Is it a bug in ArcGIS 10.1 (in connection with Oracle)?
0 Kudos
11 Replies
JeffPace
MVP Alum

Did anyone ever find a solution to this? WE just ran into this (SDE 10.2.2 on Oracle11g)

0 Kudos
PanagiotisPapadopoulos
Esri Regular Contributor

If the the layer you are using is a query layer you need to enable the St_Geometry library on Oracle Server. 

Configure the extproc to access ST_Geometry in Oracle—Help | ArcGIS Desktop 

0 Kudos