7.157 SDO_GEOR.validateBlockMBR
Format
SDO_GEOR.validateBlockMBR( georaster IN SDO_GEORASTER ) RETURN VARCHAR2;
Description
Validates the blockMBR attribute of each block of a GeoRaster object.
Usage Notes
This function checks the blockMBR attribute (described in blockMBR Attribute) in each row of the raster data table associated with the specified GeoRaster object to see if its geometry is the actual minimum bounding rectangle (MBR) of that block.
This function returns the string TRUE if the blockMBR attribute is the MBR of each block, a null value if the GeoRaster object is null, an Oracle error code if the error is known, or FALSE for an unknown error.
If you created the GeoRaster object as described in Creating New GeoRaster Objects, the blockMBR attribute values were automatically calculated and they should not need to be validated or generated. However, if the GeoRaster object was generated by a third party, you should validate the blockMBR attribute values using this function; and if any are not valid, call the SDO_GEOR.generateBlockMBR procedure.
Examples
The following example validates the blockMBR attribute of each block of a specified GeoRaster object.
SELECT sdo_geor.validateBlockMBR(georaster) FROM georaster_table WHERE georid=1; SDO_GEOR.VALIDATEBLOCKMBR(GEORASTER) -------------------------------------------------------------------------------- TRUE
Parent topic: SDO_GEOR Package Reference