Oracle Spatial Not Extruding MultiPolygon Error 29532 And java.lang.NumberFormatException: For input string: "ORA-2" (Doc ID 1586510.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Polygon with inner polygons fails to extrude:
Note the error is java.lang.NumberFormatException: For input string: "ORA-2"
  
  SELECT SDO_UTIL.EXTRUDE(GEOLOC,
  SDO_NUMBER_ARRAY(-1.0),
  SDO_NUMBER_ARRAY(1.0),
  0.0001) from TEMP_2D_SPACE
  where point_id=1901;
  
  *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.NumberFormatException: For input string: "ORA-2"
ORA-06512: at "MDSYS.SDO_UTIL", line 2543
ORA-06512: at "MDSYS.SDO_UTIL", line 2562
ORA-06512: at line 1
  
Polygon with inner polygons fails to extrude:
Note the error is ORA-54550: input 2-D polygon not valid
  
  SELECT SDO_UTIL.EXTRUDE(GEOLOC,
  SDO_NUMBER_ARRAY(-1.0),
  SDO_NUMBER_ARRAY(1.0),
  0.0001) from TEMP_2D_SPACE
  where point_id=4901;
  
  *
ERROR at line 1:
ORA-54550: input 2-D polygon not valid
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_UTIL", line 2570
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms