7.117 SDO_GEOR.setBinTable
Format
SDO_GEOR.setBinTable( georaster IN OUT SDO_GEORASTER, layerNumber IN NUMBER, tableName IN VARCHAR2);
Description
Sets the name of the bin table associated with a layer, or deletes the existing value if you specify a null tableName
parameter.
Note:
GeoRaster does not perform operations using the bin table in the current release.
Parameters
Usage Notes
The GeoRaster object is automatically validated after the operation completes.
This procedure is relevant only if the bin type is EXPLICIT
. To retrieve the bin type, use the SDO_GEOR.getBinType function.
To return the bin table for a layer, use the SDO_GEOR.getBinTable function.
See also the information in the Usage Notes for the SDO_GEOR.getBinType 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 BINT1
as the name of the bin table for layer number 3 of a specified GeoRaster object in the GEORASTER_TABLE 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.setBinTable(grobj, 3, 'BINT1'); UPDATE georaster_table SET georaster = grobj WHERE georid=4; COMMIT; END; /
Parent topic: SDO_GEOR Package Reference