BUG
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(+)"
The cause of the problem is an invalid SQL statement generated by ArcSDE when querying the view.
Get help from ArcGIS experts
Download the Esri Support App