Bug: Spatial queries on raster catalogs with SDO_GEORASTER and SDO_GEOMETRY or ST_GEOMETRY columns fail with ORACLE ORA-21500 error
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.
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:
Instead, the following storage parameter combinations should be used if the intention is to store the raster catalog data in an SDO_GEORASTER: