7.36 SDO_GEOR.getBinFunction
Format
SDO_GEOR.getBinFunction( georaster IN SDO_GEORASTER, layerNumber IN NUMBER ) RETURN SDO_NUMBER_ARRAY;
Description
Gets the bin function associated with a layer.
Parameters
Usage Notes
This function returns the bin function as an array whose elements specify the bin type, total number of bins, first bin number, minimum cell value, and maximum cell value. The SDO_NUMBER_ARRAY type is defined as VARRAY(1048576) OF NUMBER
.
If the bin type is EXPLICIT
, an external bin table is used and this function returns a null value.
For a more detailed explanation of the bin function format, see the Usage Notes for the SDO_GEOR.setBinFunction procedure.
An exception is raised if layerNumber
is null, negative, or greater than the maximum layer number.
Examples
The following example gets the bin function for layer 3 of a specified GeoRaster object.
SELECT sdo_geor.getBinFunction(georaster,3) FROM georaster_table WHERE georid=4; SDO_GEOR.GETBINFUNCTION(GEORASTER,3) -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(0, 10, 1, 0, 511)
Parent topic: SDO_GEOR Package Reference