ORA-13488: cannot perform transformation: Rectify, cannot project on Georaster operations (Doc ID 2445144.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Transformation functions on Georaster data fail with errors

DECLARE
gr1 sdo_georaster;
gr3 sdo_georaster;
win sdo_geometry := NULL;
pto sdo_geometry;
l_georid NUMBER := 162;
l_ult sdo_number_array;
BEGIN
--get ULT coordinate as a reference point
SELECT sdo_geor.getULTCoordinate(georaster) INTO l_ult FROM <table> WHERE
georid=l_georid;
SELECT sdo_geor.getModelCoordinate(georaster, 0,
sdo_number_array(l_ult(1)-0.5,l_ult(2)-0.5)) INTO pto FROM <table> WHERE
georid=l_georid;
SELECT georaster INTO gr1 FROM <table> WHERE georid = 2;
INSERT
INTO <table>
  (
  georid,
  source_file,
  description,
  georaster
  )
  VALUES
  (
  9,
  ....,
  ....,
  sdo_geor.init('<table>',9)
  )
RETURNING georaster
INTO gr3;
sdo_geor.rectify(inGeoRaster => gr1
  , pyramidLevel => 0
  , elevationParam => NULL
  , dem => NULL
  , outSRID => 32632
  , outModelCoordLoc => 0
  , cropArea => win
  , polygonClip => 'true'
  , layerNumbers => NULL
  , outResolutions => sdo_number_array(30,30)
  , resolutionUnit => 'unit=meter'
  , referencePoint => pto
  , resampleParam => 'resampling=NN'
  , storageParam => 'blockSize=(512,512,3) blocking=OPTIMALPADDING'
  , outGeoraster => gr3);
UPDATE <table> SET georaster = gr3 WHERE georid = 9;
COMMIT;
END;

the following error occurs.

ERROR
-----------------------
ORA-13488: cannot perform transformation: Rectify, cannot project.
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 7813
ORA-06512: at "MDSYS.SDO_GEOR", line 7716
ORA-06512: at "MDSYS.SDO_GEOR", line 7783
ORA-06512: at line 30

Changes

Cause

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