Problem: Spatial and by Attribute Selections Are Disabled for an XYEvent Layer Created fro

Description

When an XYEvent layer has been created from an Oracle table (connected via an Oracle OLE DB provider), spatial and by attribute selections are disabled even though the source table does have a unique index defined on an integer field (Oracle data type number(n)).

Cause

This is a data type mapping issue when using the Oracle 8.1.6 OLE DB provider to make the connection to the Oracle database.

Solution or Workaround

Use an Oracle ODBC driver to make the connection. Integer fields will be mapped to short integer/long integer data types. You can use any of these fields as a temporary ObjectID field when creating an XYEvent layer from the Oracle table.

Article ID:000003831

Software:

ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Spatial and by attribute selections are disabled for an XYEvent layer created from an Oracle table

Description

Cause

Solution or Workaround

Discover more on this topic