SDO_UTIL.FROM_WKTGEOMETRY fails with ORA-29532 OutOfMemory error on large Geometry
(Doc ID 1102474.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Spatial - Version: 188.8.131.52 to 184.108.40.206 - Release: 11.1 to 11.2
Oracle Server - Enterprise Edition - Version: 220.127.116.11 to 18.104.22.168 [Release: 11.1 to 11.2]
Information in this document applies to any platform.
reading large geometry wkt
read large geometry wkt length = 345084
converting large wkt geometry to sdo
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError
ORA-06512: at "MDSYS.SDO_UTIL", line 182
ORA-06512: at line 17
It works fine for smaller WKT geometries:
dbms_output.put_line('reading small geometry wkt');
select wkt into geom_wkt from geometry_data where name='SMALL';
dbms_output.put_line('read small geometry wkt length = '||LENGTH(geom_wkt));
reading small geometry wkt
read small geometry wkt length = 1426
converting small wkt geometry to sdo
small geometry vertices = 40
PL/SQL procedure successfully completed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document