COMPILE NOTE
============

Set DEBUG 0 in read.h and recompile to turn off prints


DESCRIPTION
===========
Program first performs a spatial search on georaster.spatialextent to get back a candidate set 
of georaster objects.

For each georaster returned, program performs a sdo_geor.getRasterSubset.

This is only an example application. You could modify this example to build a pick list
from the georaster.spatialextent search, and only call sdo_geor.getRasterSubset when a user
picks a georaster from your list.


SAMPLE CALLS TO PROGRAM
=======================

For a list of command line parameters for read_oci, type read_oci by itself at the command line.


Sample call in model space with :
  -- Box query window
  -- WGS84 SRID (8307)
read_oci scott tiger dan_geor geor B 8307 0,0,1,1


Sample call in cell space with:
  -- Box query window
  -- NULL SRID (which is how you specify cell space search)
read_oci dan dan uk_rasters georaster B NULL 0,0,50,50

Sample call in model space with:
  -- Polygon query window 
  -- Note:
          -- polygon search will be invoked against georaster.spatialextent
          -- sdo_geor.getRasterSubset implicitly converts the polygon 
             to an MBR of the polgon for the clip
  -- WGS84 SRID (8307)
read_oci dan dan uk_rasters georaster P 8307 0.250,0.250,0.500,10.3,-0.50,7.50,0.250,0.250


EXAMPLE OF CREATING A SPATIAL INDEX ON GEORASTER.SPATIAL_EXTENT
===============================================================
delete from user_sdo_geom_metadata where table_name = 'UK_RASTERS';
insert into user_sdo_geom_metadata values
  ('UK_RASTERS', 'GEORASTER.SPATIALEXTENT',
   mdsys.sdo_dim_array(mdsys.sdo_dim_element('X', -180, 180, .05),
                       mdsys.sdo_dim_element('Y',  -90,  90, .05)),
  8307
);
commit;

drop index uk_rasters_sidx;
create index uk_rasters_sidx on uk_rasters(georaster.spatialExtent)
  indextype is mdsys.spatial_index;