My Oracle Support Banner

SDO_UTIL.AFFINETRANSFORMS Fails With ORA-29532 And ORA-06512 In 11.2 (Doc ID 970708.1)

Last updated on MARCH 28, 2019

Applies to:

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

Symptoms

Affine transformation fails in 11.2.

SELECT SDO_UTIL.AFFINETRANSFORMS(
   geometry => MDSYS.SDO_GEOMETRY(2003, NULL, NULL,
               MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),
               MDSYS.SDO_ORDINATE_ARRAY(1.5,0,2.5,1,1.5,2,0.5,2,0.5,0,1.5,0)),
   translation => 'FALSE',
   tx => 0.0,
   ty => 0.0,
   tz => 0.0,
   scaling => 'FALSE',
   psc1 => NULL,
   sx => 0.0,
   sy => 0.0,
   sz => 0.0,
   rotation => 'FALSE',
   p1 => NULL,
   line1 => NULL,
   angle => 0.0,
   dir => 0,
   shearing => 'FALSE',
   shxy => 0.0,
   shyx => 0.0,
   shxz => 0.0,
   shzx => 0.0,
   shyz => 0.0,
   shzy => 0.0,
   reflection => 'TRUE',
   pref => NULL,
   lineR => MDSYS.SDO_GEOMETRY(2002,0,NULL,
            MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1),
            MDSYS.SDO_ORDINATE_ARRAY(2.5,0.0,2.5,2.0)),
   dirR => 0,
   planeR => 'FALSE',
   n => NULL,
   bigD => NULL
) FROM DUAL;


ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.Exception: Invalid parameter for affine transform
ORA-06512: at "MDSYS.SDO_UTIL", line 266

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.