7.133 SDO_GEOR.setGrayScaleTable
Format
SDO_GEOR.setGrayScaleTable( georaster IN OUT SDO_GEORASTER, layerNumber IN NUMBER, tableName IN VARCHAR2);
Description
Sets the grayscale mapping table for a layer in a GeoRaster object, or deletes the existing value if you specify a null tableName
parameter.
Note:
This procedure registers the grayscale mapping table name with GeoRaster; however, GeoRaster does not perform operations using the grayscale mapping table in the current release.
Parameters
Usage Notes
SDO_GEOR_GRAYSCALE Object Type describes grayscale display.
The GeoRaster object is automatically validated after the operation completes.
To return the grayscale mapping table for a layer in a GeoRaster object, use the SDO_GEOR.getGrayScaleTable function.
An exception is raised if layerNumber
is null or invalid for the GeoRaster object, or if tableName
is an empty string (''
).
Examples
The following example sets GST1
as the grayscale mapping table for layer 3 of the GeoRaster object (GEORASTER column) in the row with the GEORID column value of 4 in the GEORASTER_TABLE table. (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=4 FOR UPDATE; sdo_geor.setGrayScaleTable(grobj, 3, 'GST1'); UPDATE georaster_table SET georaster = grobj WHERE georid=4; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference