[Gdal-dev] trouble on using ogr2ogr from Oracle Spatial to shp

[Francesco Sozzi]

Hi Frank,

Thanks for help, now I compiled fine.

The problem now is using ogr2ogr.
I would like to transform geometries from Oracle Spatial to shp.
If I try with a point layer it works.
But with polylines and polygons I get shp file with data but no geometries..

The command I used is:
ogr2ogr -f "ESRI Shapefile" c:/trash/test2.shp 
OCI:ti_catstrade/avs at franz:IC_AREEVERDI

Please note that this layer passes Oracle validation test and I can open 
with Mapserver.

Any suggestions?...

Bets regards

Francesco

----- Original Message ----- 
From: "Frank Warmerdam" <warmerdam at pobox.com>
To: "Francesco Sozzi" <fsozzi at intercad.ch>
Cc: <gdal-dev at lists.maptools.org>
Sent: Wednesday, December 20, 2006 2:50 AM
Subject: Re: [Gdal-dev] trouble on compiling and using ogr with Oracle 
Spatial


> Francesco Sozzi wrote:
>> Hi All,
>>  I'm trying to compile ogr with Oracle Spatial.
>> I changed nmake.opt with the following:
>>  # Add ORACLE support.
>> ORACLE_HOME = D:\oracle\ora92
>>
>> !IFDEF ORACLE_HOME
>> OCI_LIB = $(ORACLE_HOME)\oci\lib\msvc\ociw32.lib \
>> $(ORACLE_HOME)\oci\lib\msvc\oci.lib
>> !ENDIF
>>
>> ORACLE_HOME path is correct.
>>
>> Then I compiled and I got binaries (such as ogr2ogr.exe).
>>
>> But if I try to issue a test as
>>
>> ogr2ogr -f OCI OCI:scott/tiger at franz C:\App\TI-CantoneSHP\comuni.shp
>>
>> I get the error "Unable to find driver 'OCI'"
>
> Francesco,
>
> After changing the nmake.opt file, you need to do a "nmake /f makefile.vc
> clean" before doing the build again.  Is it possible you missed this step?
> By the way, "ogrinfo --formats" should list all the available drivers. 
> You
> can use it to verify you got the OCI driver.
>
> Also be careful that the update GDAL DLL is actually being used, not some
> older build of the DLL or copy from some other package.  The easiest way 
> to
> verify this is to delete the old one, and verify that ogrinfo can't find a
> GDAL DLL.  Then rebuild and replace it, and try again.
>
> Best regards,
> -- 
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam, 
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | President OSGeo, http://osgeo.org
>
>