7.21 SDO_GEOR.generateBlockMBR
Format
SDO_GEOR.generateBlockMBR( georaster IN SDO_GEORASTER);
Description
Computes the minimum bounding rectangle (MBR) for each block in a GeoRaster object, and sets the blockMBR
attribute for each raster block in the raster data table.
Usage Notes
This procedure does not change the GeoRaster object. It sets the value of the blockMBR
attribute (described in blockMBR Attribute) in each row of the raster data table associated with the GeoRaster object.
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 the SDO_GEOR.validateBlockMBR function; and if any are not valid, call the SDO_GEOR.generateBlockMBR procedure.
Examples
The following example computes the MBR for a specified GeoRaster object and sets its blockMBR
attribute.
DECLARE gr sdo_georaster; BEGIN SELECT georaster INTO gr FROM georaster_table WHERE georid=1 FOR UPDATE; sdo_geor.generateBlockMBR(gr); COMMIT; END; /
Parent topic: SDO_GEOR Package Reference