GDAL Georaster Use the Compression type import raster can't build pyramid!

[bicealyh]

I use GDAL Georaster component import raster data into Oracle Georaster. When I use the compress type such like DEFLATE, JPEG-B or JPEG-F to import raster to Oracle Georaster, it can't build pyramid and give me some Oracle errors, like below: ORA-29400: 数据插件错误ORA-13485: 压缩或解压缩时出错: 空二进制大对象操作无效 ORA-06512: 在 "MDSYS.MD", line 1723 ORA-06512: 在 "MDSYS.MDERR", line 17 ORA-06512: 在 "MDSYS.SDO_GEOR_AUX", line 315 ORA-06512: 在 line 13 ORA-06512: 在 "MDSYS.SDO_GEOR_INT", line 541 ORA-06512: 在 "MDSYS.SDO_GEOR", line 1017 ORA-06512: 在 line 7

[ilucena]

Building pyramids is a task for internal Oracle's software.

If you run gdaladdo in debugging mode you will see the PL/SQL statement that does that:

gdaladdo geor:scott/tiger@orcl,gdal_rdt,207 2 4 8 16 32 64 128 --debug on
0...10PL/SQL:
DECLARE
  gr sdo_georaster;
BEGIN
  SELECT RASTER INTO gr FROM GDAL_IMPORT t WHERE T.RASTER.RASTERDATATABLE = UPPER('gdal_rdt') AND T.RASTER.RASTERID = 207 FOR UPDATE;
  sdo_geor.generatePyramid(gr, 'rlevel=7 resampling=NN');
  UPDATE GDAL_IMPORT t SET RASTER = gr WHERE T.RASTER.RASTERDATATABLE = UPPER('gdal_rdt') AND T.RASTER.RASTERID = 207;
  COMMIT;
END;

[Even Rouault]

Removing obsolete milestone

[Even Rouault]

All those tickets have more than one year and nobody has acted on it, so the priority is not so high

[Even Rouault]

This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to ​https://github.com/OSGeo/gdal/issues if it is not already reported there.