Problem using st_linefromtext on "large" linestrings in 10.1

453
1
03-06-2013 07:05 PM
idolevi
New Contributor
Environment: Arc SDE 10.1 , Oracle 11g r2, Arcgis Server 10.1

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

Does Arcgis 10.1 has size limitation?

Thanks,
Ido
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
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.

- V
0 Kudos