that is a good news ! so now I need just to wait that the OSGeo4W team add the gdal17-oracle package.
thanks ! On Tue, Jul 13, 2010 at 2:11 AM, Ivan Lucena <[email protected]> wrote: > I just noticed from your ticket [http://trac.osgeo.org/gdal/ticket/3681] that > you are using GDAL 1.6.3. Right? > > A lot has changed since then. I run the same sequence of options as you and > everything works fine in GDAL 1.8dev. > > I believe it should work fine with the current released version too. GDAL > 1.7.2. > > Please update it and try again. > > Regards. > >> -------Original Message------- >> From: Pasta Bolognese <[email protected]> >> To: Ivan Lucena <[email protected]> >> Cc: [email protected] >> Subject: Re: [gdal-dev] GeoRaster: problem updating on predefined existing >> table >> Sent: Jul 12 '10 09:59 >> >> doing more experiments it results that the error is given ONLY when >> the schema is given. >> >> gdal_translate -of georaster c:\tmp\map.png ^ >> georaster:geoserver/geoserver,MFDEVDB,GEOSERVER.PASTA >> _RASTERS,raster ^ >> -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))" >> >> It is using the table GEOSERVER.PASTA _RASTERS. It would work only >> once. After that it would give the same error ORA-00955) >> >> gdal_translate -of georaster c:\tmp\map.png ^ >> georaster:geoserver/geoserver,MFDEVDB,PASTA _RASTERS,raster ^ >> -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))" >> >> It is using the table PASTA _RASTERSThis would work all the time.. >> >> Is it working as expected ? >> >> On Mon, Jul 12, 2010 at 2:54 PM, Pasta Bolognese >> <[email protected]> wrote: >> >> > >> >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> >> > georaster:geoserver/geoserver,MFDEVDB >> >> > >> >> > and it works well. Then I've imported another immage using the same >> >> > command and it worked well too ! >> >> >> >> Note that you didn't specify table & column so a table named >> "GDAL_IMPORT", column "RASTER" was created for you as default. >> > >> > exactly >> > >> >> >> >> > >> >> > Then I have decided to use a predefined table.... and here the >> problems: >> >> > >> >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> >> > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta >> >> >> >> This command is missing the column name after "schema.table" so it is >> assuming column name "RASTER" as default. Does the table "pasta" existed >> before that command? >> > >> > exactly. The table PASTA is created automatically by the command itself. >> > >> >> >> >> > Input file size is 1014, 863 >> >> > 0...10...20...30...40...50...60...70...80...90...100 - done. >> >> > Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_33$,33) on >> >> > PASTA,RASTER >> >> > >> > >> > at this point the table is created by GDAL >> > >> >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> >> > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta >> >> > Input file size is 1014, 863 >> >> > ERROR 1: ORA-00955: name is already used by an existing object >> >> > ORA-06512: at line 10 >> >> > >> >> > ERROR 1: Create Table Error! >> >> > >> >> >> >> Again, this command is missing the column name too, so I believe it is >> trying to re-create the table "Pasta" with column "RASTER". Whatever is >> happening is caused by the error on the command. >> >> >> > >> > At this point GDAL should add a new line to the same table.... >> > >> > infact even giving the table name and the column name: (again, the >> > table is created automatically by GDAL) >> > >> > >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster >> > Input file size is 1014, 863 >> > 0...10...20...30...40...50...60...70...80...90...100 - done. >> > Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_42$,42) on >> > PASTA,RASTER >> > >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster >> > Input file size is 1014, 863 >> > ERROR 1: ORA-00955: name is already used by an existing object >> > ORA-06512: at line 10 >> > >> > ERROR 1: Create Table Error! >> > >> > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
