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

Last updated on FEBRUARY 15, 2010

Applies to:

Oracle Spatial - Version: 11.2.0.1 - Release: 11.2
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

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