Compile with Oracle support

[Fernando Simon]

Hi Berend,
   To compile Mapserver with Oracle Spatial support you need the Oracle 
Call Interfaces (OCI) library installed in the system. You can install 
it from the client cd or server cd.
   The flag --with-oraclespatial need to appoint for ORACLE_HOME.
   Thanks.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------


Berend Veldkamp wrote:

> Hello list,
>
> I have some problems compiling MapServer (4.6.1 on Linux) with support 
> for Oracle. I have installed Oracle Instant Client 10g in the 
> directory suggested by Oracle: /usr/lib/oracle/10g/client. The header 
> files are located in /usr/lib/oracle/10g/client/sdk/include.
>
> Here's what I did:
>
> export CPPFLAGS=-I/usr/lib/oracle/10g/client/sdk/include
>
> ./configure --with-proj --without-pdf --with-gd=/usr --with-freetype 
> --with-gdal --with-ogr --with-php=../php-4.3.11 --with-postgis 
> --with-geos --with-wfs --with-wfsclient --with-wcs --with-wms 
> --with-wmsclient --with-oraclespatial=/usr/lib/oracle/10g/client
>
> make
>
> After some time I get this error:
> gcc -c -O2 -fPIC -Wall   -DIGNORE_MISSING_DATA  -DNEED_STRLCAT 
> -DUSE_EPPL -DUSE_PROJ -DUSE_WMS_SVR -DUSE_WMS_LYR -DUSE_WFS_SVR 
> -DUSE_WFS_LYR -DUSE_WCS_SVR  -DUSE_ORACLESPATIAL   -DUSE_GD_GIF 
> -DUSE_GD_PNG -DUSE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT 
> -DGD_HAS_GDIMAGEGIFPTR -DGD_HAS_GETBITMAPFONTS    -DUSE_OGR -DUSE_GDAL 
> -DUSE_GEOS -DUSE_ICONV    -DUSE_POSTGIS    -DUSE_ZLIB -I/usr/include 
>     -I/usr/local/include -I/usr/local/pgsql/include 
> -I/usr/lib/oracle/10g/client/rdbms/demo 
> -I/usr/lib/oracle/10g/client/rdbms/public -I/usr/local/include 
> maporaclespatial.c -o maporaclespatial.o
> maporaclespatial.c:129:17: oci.h: No such file or directory
>
> It seems that the CPPFLAGS environment variable is not used at all, 
> and instead two subdirectories (rdbms/demo and rdbms/public) of 
> ORACLE_HOME are used. Both directories are non-existant.
>
> Besides moving the Oracle installation, is there anything else I can do?
>
> Thanks, Berend
>
>