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"
Article ID:000008775
- Legacy Products
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App