mapserver 4.4.0 / Oracle 9.2.0.4 on SuSE SLES9

[Fernando S.]

Hi Benjamin,
    You need to install "Oracle Call Interface" for install oci.h. This
is the best way to add this support.
    Thanks.

----------------------------------------------------------------
Fernando Simon - simon at inf.univali.br
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada
http://g10.cttmar.univali.br
----------------------------------------------------------------

Benjamin Thelen wrote:

> Hi,
>
> are there any tricks to get mapserver 4.4.0 compiled with Oracle?
> Compiling mapserver 4.2.5 on the same machine with oracle was no
> problem at all!
> As far as I know, it isn't required to install oracle server, oracle
> client is sufficient - at least under windows.
>
> Please look at the following error:
>
> SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
> -DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
> SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
> -DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
>  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
> -I/usr/include/pgsql    -I/opt/oracle/O
> raHome1/rdbms/demo -I/opt/oracle/OraHome1/rdbms/public    mapwms.c -o
> mapwms.o
> gcc -c -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT
> -DUSE_PROJ -DUSE_PROJ_API_H -DUSE_WMS
> _SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
> -DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
> SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
> -DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
>  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
> -I/usr/include/pgsql    -I/opt/oracle/O
> raHome1/rdbms/demo -I/opt/oracle/OraHome1/rdbms/public
> mapwmslayer.c -o mapwmslayer.o
> gcc -c -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT
> -DUSE_PROJ -DUSE_PROJ_API_H -DUSE_WMS
> _SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
> -DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
> SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
> -DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
>  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
> -I/usr/include/pgsql    -I/opt/oracle/O
> raHome1/rdbms/demo -I/opt/oracle/OraHome1/rdbms/public
> maporaclespatial.c -o maporaclespatial.o
> maporaclespatial.c:107:17: oci.h: No such file or directory
>                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> maporaclespatial.c:125: error: parse error before "OCINumber"
> maporaclespatial.c:125: warning: no semicolon at end of struct or union
> maporaclespatial.c:126: warning: type defaults to `int' in declaration
> of `y'
> maporaclespatial.c:126: warning: data definition has no type or
> storage class
> maporaclespatial.c:127: error: parse error before "z"
> maporaclespatial.c:127: warning: type defaults to `int' in declaration
> of `z'
> maporaclespatial.c:127: warning: data definition has no type or
> storage class
> maporaclespatial.c:129: warning: type defaults to `int' in declaration
> of `SDOPointObj'
> maporaclespatial.c:129: warning: data definition has no type or
> storage class
> maporaclespatial.c:133: error: parse error before "OCINumber"
> maporaclespatial.c:133: warning: no semicolon at end of struct or union
> maporaclespatial.c:134: warning: type defaults to `int' in declaration
> of `srid'
> maporaclespatial.c:134: warning: data definition has no type or
> storage class
> maporaclespatial.c:135: error: parse error before "point"
> maporaclespatial.c:135: warning: type defaults to `int' in declaration
> of `point'
> maporaclespatial.c:135: warning: data definition has no type or
> storage cla
>
>
>
>
>
>
> Indeed, there is no oci.h! I found one on a oracle server installation
>  and copied this and some other missing *.h files to
>
> /OraHome/../rdbms/demo/
> /OraHome/../rdbms/public/
>
>
> on the oracle client machine. But the same error occured again.
>
> I then copied these *.h files to /usr/local, what caused another
> error. Please see below. I suppose, that copy some files some where
> wasn't the best thing I could do :-)!
>
>
> gcc -c -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT
> -DUSE_PROJ -DUSE_PROJ_API_H -DUSE_WMS
> _SVR -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
> -DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DU
> SE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS
> -DUSE_OGR -DUSE_GDAL  -DUSE_ICONV
>  -DUSE_POSTGIS    -I/usr/include        -I/usr/local/include
> -I/usr/include/pgsql    -I/opt/oracle/r
> dbms/demo -I/opt/oracle/rdbms/public    shp2img.c -o shp2img.o
> gcc -O2 -fPIC  -Wall -DIGNORE_MISSING_DATA -DNEED_STRLCAT   -DUSE_PROJ
> -DUSE_PROJ_API_H -DUSE_WMS_SV
> R -DUSE_WMS_LYR -DUSE_WFS_SVR -DUSE_WFS_LYR -DUSE_WCS_SVR
> -DUSE_ORACLESPATIAL   -DUSE_GD_PNG -DUSE_
> GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_GETBITMAPFONTS    -DUSE_OGR
> -DUSE_GDAL  -DUSE_ICONV    -D
> USE_POSTGIS    -I/usr/include        -I/usr/local/include
> -I/usr/include/pgsql    -I/opt/oracle/rdbm
> s/demo -I/opt/oracle/rdbms/public    shp2img.o  -L. -lmap -lgd
> -L/usr/lib -lgd -ljpeg -lfreetype -lp
> ng -lz    -ljpeg -lfreetype -lpng -lz   -lproj -ljpeg
> -L/usr/local/lib -lgdal  -L/usr/lib -lpq  -L/
> usr/lib -lcurl -L/usr/ssl/lib -lz -lssl -lcrypto -ldl
> -L/opt/oracle/lib -lclntsh    -lc  -lm -lstdc+
> +  -o shp2img
> /usr/lib/gcc-lib/i586-suse-linux/3.3.3/../../../../i586-suse-linux/bin/ld:
>
>
> cannot find -lclntsh
> collect2: ld returned 1 exit status
> make: *** [shp2img] Error 1
>
>
>
> Has somebody any idea? What about this oci.h? Why is it missing on the
> oracle client. Why does ms-4.2.5 compile successfully? What can I do
> with ms-4.4.0?
>
> Thanks for any help!
>
> Best Regards,
> Benjamin
>