7.136 SDO_GEOR.setLayerID
Format
SDO_GEOR.setLayerID( georaster IN OUT SDO_GEORASTER, layerNumber IN NUMBER, id IN VARCHAR2);
Description
Sets a user-defined identifier to be associated with a layer in a GeoRaster object, or deletes the existing value if you specify a null id
parameter.
Parameters
Usage Notes
The GeoRaster object is automatically validated after the operation completes.
To return the user-defined identifier value for a layer in a GeoRaster object, use the SDO_GEOR.getLayerID function.
An exception is raised if layerNumber
is null or invalid for the GeoRaster object, or if id
is null yet the corresponding layer information does exist.
Examples
The following example sets TM_Band_2
as the user-defined identifier value of layer 2 in 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.setLayerID(grobj, 2, 'TM_Band_2'); UPDATE georaster_table SET georaster = grobj WHERE georid=4; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference