Is This Content Helpful?
We're glad to know this article was helpful.
Creating a selection set in ArcGIS against a view containing a ST_Geometry attribute in Oracle, can result in an underlying Oracle error:
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.
sdetable -o create_view -T land_parcels -t "land,parcels"
The cause of the problem is an invalid SQL statement generated by ArcSDE when querying the view.
Currently there is no workaround that addresses this issue.