Bug: Creating a Selection Set from a View Results in an Invalid ROWID Error

Description

Creating a selection set in ArcGIS against a view containing a ST_Geometry attribute in Oracle, can result in an underlying Oracle error:"Invalid ROWID."This error can happen when a view is created with the sdetable -o create_view command and the input table contains a ST_Geometry attribute.

Code:
sdetable -o create_view -T land_parcels -t "land,parcels" 
-c "parcels.objectid,parcels.shape,parcels.parid,land.taxyr,land.ltype,land.code" 
-w "parcels.parid=land.parid(+)"

When the view is added to ArcMap and the session creates a selection set (selecting more than 100 features), an underlying DBMS error returns the invalid ROWID message.

Cause

The cause of the problem is an invalid SQL statement generated by ArcSDE when querying the view.

Workaround

Currently there is no workaround that addresses this issue.

Article ID:000009833

Software:

Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Creating a selection set from a view results in an invalid ROWID error

Description

Cause

Workaround

Discover more on this topic