SDO_GEOR.MOSAIC fails with ORA-13419 error

(Doc ID 1121855.1)

Last updated on JULY 12, 2010

Applies to:

Oracle Spatial - Version: 10.2.0.4 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

When attempting to use the SDO_GEOR.mosaic package I got an error message:

ORCL.KTIRUSER> DECLARE
2 gr sdo_georaster;
3 BEGIN
4 INSERT INTO EGYBEN_RASTERS (georid, georaster)
5 VALUES (1, sdo_geor.init('EGYBEN_RASTERS_RDT'))
6 RETURNING georaster INTO gr;
7 sdo_geor.mosaic('MOSAIC_TEST_RASTERS', 'georaster', gr, 'blocksize=(512,512,3)');
8 UPDATE EGYBEN_RASTERS SET georaster=gr WHERE georid=1;
9 END;
10 /
DECLARE
*
ERROR at line 1:
ORA-13419: "cannot perform mosaick operation on the specified table column"
ORA-06512: at "MDSYS.MD", line 1723.
ORA-06512: at "MDSYS.MDERR", line 8.
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 957.
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 1268.
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 1539.
ORA-06512: at "MDSYS.SDO_GEOR", line 1401.

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