Bug
Performing a spatial selection when using Spatial Type for Oracle, fails with invalid rowid when using a view.
| Bug ID Number | NIM013819 |
|---|---|
| Submitted | December 18, 2007 |
| Last Modified | June 5, 2024 |
| Applies to | No Product Found |
| Version found | 9.3 |
| Version Fixed | 9.3 |
| Status | Fixed |
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.Steps to Reproduce
Bug ID: NIM013819
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App