using gdal_translate insert raster to georaster error

[bicealyh]

D:>gdal_translate  -of georaster G:\img\test.img georaster:user/password@dbname,city_images,image -a_nodata 256 -co "DESCRIPTION=(image_id NUMBER, filename VARCHAR2(200), image MDSYS.SDO_GEORASTER,FOOTPRINT MDSYS.SDO_GEOMETRY,OBJECTID NUMBER(38),SE_ANNO_CAD_DATA BLOB)" -co "INSERT=VALUES( 5,'part4_10.img',SDO_GEOR.INIT('city_images_rdt',5),null,5,null)" -co "BLOCKXSIZE=256" -co "BLOCKYSIZE=256" -co "COMPRESS=NONE" -co "BLOCKBSIZE=1" -co "INTERLEAVE=BSQ"                                                                  Input file size is 11238, 10548                                                 0...10...20...30...40...50...60...70...80...90...100 - done.                    Ouput dataset: (georaster:sde,sde,ORCL,CITY_IMAGES_RDT,5) on SDE.CITY_IMAGES,IMAGE                                                                ERROR 1: ORA-31011: XML Parsing failed                                            
ORA-19202: XML processing                                                             
LPX-00245: After the end tag in the document there is redundant data                                      
Error at line 49                                                                 
时出错                                                                         
ORA-06512: 在 "SYS.XMLTYPE", line 310                                           
ORA-06512: 在 line 8                                        

[ilucena]

The problem seems to be caused by the attempt to load the HFA RAT as Oracle's VAT when it is only a histogram, not really an attribute table. That was fixed on http://trac.osgeo.org/gdal/changeset/17421.

[ilucena]

The revision r19946 change the way VAT is update. Please try again and in case of error, please provide a small sample file so that we can replicate the problem.

One way to do that:

gdal_translate -of hfa G:\img\test.img G:\img\test2.img -outsize 64 64