Problem using st_linefromtext on "large" linestrings in 10.1

idolevi — Thu, 07 Mar 2013 03:05:55 GMT

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

Re: Problem using st_linefromtext on "large" linestrings in 10.1

VinceAngelo — Thu, 07 Mar 2013 11:46:07 GMT

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

topic Re: Problem using st_linefromtext on "large" linestrings in 10.1 in Data Management Questions

Problem using st_linefromtext on "large" linestrings in 10.1

Re: Problem using st_linefromtext on "large" linestrings in 10.1