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
, 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