7.119 SDO_GEOR.setBlankCellValue
Format
SDO_GEOR.setBlankCellValue( georaster IN OUT SDO_GEORASTER, value IN NUMBER);
Description
Sets (modifies) the cell value to be used for all cells if a specified GeoRaster object is a blank GeoRaster object.
Parameters
Usage Notes
In a blank GeoRaster object, all cells have the same cell value.
The GeoRaster object is automatically validated after the operation completes.
To return the blank cell value of a blank GeoRaster object, use the SDO_GEOR.getBlankCellValue function. To determine if a specified GeoRaster object is a blank GeoRaster object, use the SDO_GEOR.isBlank function.
An exception is raised if value
is null or inconsistent with the cellDepth
specification, or if the GeoRaster object is not blank.
Examples
The following example specifies a value of 255 to be used for all cells in the GeoRaster object column (GEORASTER) in the GEORASTER_TABLE table for the row with an GEORID column value of 1. (The GEORASTER_TABLE table definition is presented after Example 1-1 in Storage Parameters.)
DECLARE grobj sdo_georaster; BEGIN SELECT georaster INTO grobj FROM georaster_table WHERE georid=1 FOR UPDATE; sdo_geor.setBlankCellValue(grobj, 255); UPDATE georaster_table SET georaster = grobj WHERE georid=1; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference