Hi, I have table with linestring clob column, the linestring are larger than 4000 bytes. When I try to do a select using sde.st_linefromtext on the clob column, i get: System.Data.OracleClient.OracleException: ORA-20004: Error generating shape from text: Invalid text used to construct geometry (-1). ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12 ORA-06512: at "SDE.ST_LINEFROMTEXT", line 58
But it works fine when I run the same select on the same column in different environment: Arc SDE 10 , Oracle 10, Arcgis Server 10
This is certainly something to take to Tech Support. Be sure you provide them with the exact service pack (and patch, if present) [ArcGIS] or patchset [Oracle] installed on your servers and clients (for both Oracle and ArcGIS). If you're not using 10.1 SP1, you should also test it.