English

Bug: Spatial queries on raster catalogs with SDO_GEORASTER and SDO_GEOMETRY or ST_GEOMETRY columns fail with ORACLE ORA-21500 error

Description

Spatial queries that include both an SDO_GEORASTER and a geometry type (SDO_GEOMETRY or ST_GEOMETRY) fail with an ORACLE ORA-21500 error.

For example, if there is a raster catalog with a raster column stored as an SDO_GEORASTER and a geometry column stored as either an SDO_GEOMETRY or an ST_GEOMETRY, load data into the raster catalog, then open the raster catalog in ArcMap and pan and zoom across the data of the raster catalog, the ORACLE ORA-21500 error occurs.

Cause

According to Oracle documentation, the ORA-21500 error is a generic error number for OCI environment (client-side) internal errors indicating the OCI environment has encountered an exceptional condition. Therefore, using raster catalogs that contain both an SDO_GEORASTER and an SDO_GEOMETRY or ST_GEOMETRY column is not allowed at this time.

Workaround

If the intention is to store raster catalog data in an SDO_GEORASTER column, choose either a BLOB or a LONG RAW column to store the raster catalog's polygon footprints.

In the configuration keyword used to create the raster catalog, the following storage parameters should not be combined:

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "SDO_GEOMETRY"

or

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "ST_GEOMETRY"

Instead, the following storage parameter combinations should be used if the intention is to store the raster catalog data in an SDO_GEORASTER:

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "SDELOB"

or

RASTER_STORAGE "SDO_GEORASTER"
GEOMETRY_STORAGE "SDEBINARY"