I have a georaster (called carbon) that has a NODATA value set to -9.
All other cell values are ≥ 0.0.
I wish to change the NODATA cell values in the georaster to -999999.
I have tried the following but the update didn't occur.
Can anyone spot what I am doing wrong?
select t.lb from carbon a, SDO_GEOR.getNODATA(a.raster, 0) t;
LB
----------
-9
declare
gr sdo_georaster;
begin
select raster into gr from carbon;
sdo_geor_ra.rasterUpdate(geoRaster => gr,
pyramidLevel => 0,
conditions => SDO_STRING2_ARRAY('{0}<0'),
vals => SDO_STRING2_ARRAYSET(SDO_STRING2_ARRAY('-999999')),
bgValues => NULL,
nodata => 'FALSE');
UPDATE carbon SET raster=gr;
commit;
end;
/
select t.lb from carbon a, SDO_GEOR.getNODATA(a.raster, 0) t;
LB
----------
-9