AnsweredAssumed Answered

Too many points for ST_GEOMETRY to handle?

Question asked by json.ajax on Feb 4, 2015
Latest reply on Feb 5, 2015 by vangelo-esristaff

Hi all,


I am writing a PL/SQL procedure to create a linestring from a set of given points in a point feature class with ST_GEOMETRY function calls and then insert into a line feature class. My script seems working only with a small number of points like 320 points (where CLOB char count is 10991). If I added more points (CLOB char count is 11041), the same script, specifically the ST_GEOMETRY creation statement


st_linefromtext(v_shp_clob, v_geo_srid));


, threw an error: ORA-20004: Error generating shape from text: Invalid text used to construct geometry (-1). A worse error appeared: ORA-20000: Failed to get Geometry text Memory when the number of points was 17840.


I didn't find any parameter on SDE or ST_GEOMETRY to specify the limitation. Oracle has too big numbers for CLOB size or BUFFER to pose this limit. Has anybody here run into this error and find a way to handle it?


My env is Oracle 11gR2 and SDE 10.1 on Linux