7.129 SDO_GEOR.setEndDateTime
Format
SDO_GEOR.setEndDateTime( georaster IN OUT SDO_GEORASTER, endTime IN TIMESTAMP WITH TIME ZONE);
Description
Sets the ending date and time for raster data collection in the metadata for a GeoRaster object, or deletes the existing value if you specify a null endTime
parameter.
Usage Notes
The GeoRaster object is automatically validated after the operation completes.
To see the current ending date and time (if any) in the metadata for the GeoRaster object, use the SDO_GEOR.getEndDateTime function.
An exception is raised if endTime
is earlier than the beginning date and time specified in the metadata for the GeoRaster object (see the SDO_GEOR.setBeginDateTime procedure).
Examples
The following example sets the beginning and ending dates and times for raster data collection in the metadata for a GeoRaster object. (It refers to a table named GEORASTER_TABLE, whose 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.setBeginDateTime(grobj, timestamp '2002-11-15 15:00:00'); sdo_geor.setEndDateTime(grobj, timestamp '2002-11-15 15:00:10'); UPDATE georaster_table SET georaster = grobj WHERE georid=4; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference