7.135 SDO_GEOR.setID
Format
SDO_GEOR.setID( georaster IN OUT SDO_GEORASTER, id IN VARCHAR2);
Description
Sets a user-defined identifier to be associated with a GeoRaster object, or deletes the existing value if you specify a null id
parameter.
Usage Notes
This procedure is useful for assigning unique meaningful alphanumeric identifiers to GeoRaster objects, so that users and applications can easily identify the objects.
The GeoRaster object is automatically validated after the operation completes.
To return the user-defined identifier value for a GeoRaster object, use the SDO_GEOR.getID function.
Examples
The following example sets newid
as the user-defined identifier value of the GeoRaster object (GEORASTER column) in the row with the GEORID column value of 2 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=2 FOR UPDATE; sdo_geor.setID(grobj, 'newid'); UPDATE georaster_table SET georaster = grobj WHERE georid=2; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference