7.114 SDO_GEOR.schemaValidate
Format
SDO_GEOR.schemaValidate( georaster IN SDO_GEORASTER ) RETURN VARCHAR2;
Description
Validates a GeoRaster object's metadata against the GeoRaster XML schema.
Usage Notes
This function returns the string TRUE
if the metadata is valid, a null value if the GeoRaster object or its metadata is null, or one or more Oracle error codes indicating why the metadata is not valid and the exact location of the errors.
Use this function with the SDO_GEOR.validateGeoRaster function. If the SDO_GEOR.validateGeoRaster function identifies a GeoRaster object as invalid with an error code of 13454, the object's metadata is not valid according to the GeoRaster XML schema. If this happens, call the SDO_GEOR.schemaValidate function to get specific information, including the location in the metadata, about the errors.
Examples
The following example validates a GeoRaster object's metadata.
SELECT t.georid, sdo_geor.schemavalidate(t.georaster) FROM georaster_table t WHERE t.georid = 1;
Parent topic: SDO_GEOR Package Reference