BUG
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.
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.
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"
Article ID:000008775
Get help from ArcGIS experts
Download the Esri Support App