This content has been marked as final. Show 6 replies
In your case, you don't need to get spatial extent, you can pass null to window parameter, and then statistics is calculated for the entire image.
WHERE georid=3 FOR UPDATE;
ret := SDO_GEOR.generateStatistics(gr, 'samplingFactor=1', window, 'TRUE', '0-1', 'FALSE',null,'true');
Hi, in your original script the window you passed in should be in cell space because you used the sdo_number_array. but the spatial extent and its sdo_ordinates you used to create that window is in model space. so the window it created has huge or incorrect cell coordinates, which is not overlapping with the actual image. That's why no statistics were generated. So, when you call this function, pay more attention to which prototype (cell space window vs mode space window) you would like to use and make sure the coordinates are in the right spaces.
Since you are generating the statistics for the whole image, you really don't need to use the spatialextent for the window. simply use NULL, as zzhang posted. The default is the whole raster.
That said, there is a bug here for this special case. We have just filed Bug 14021903 for it. If you need the fix for your current version, please file a Service Request.
Thank you very much.