[gdal-dev] Build OGR with Oracle support

[Normand Savard]

I'm trying to build OGR with Oracle 10g or 11.1 support through FGS.  
The problem is that the library is not found.  If you look to the 
configure output below I made the CPPFLAGS AND LDFLAGS to be printed 
out.  They both point out to the correct location.

I downloaded the basic and sdk client from 
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html


The configure switch settings are:
## oci support
OPTIONS="$OPTIONS 
--with-oci-include=$FGS_BUILD_HOME/$oci_ARCHIVE_DIR/sdk/include 
--with-oci-lib=$FGS_BUILD_HOME/$oci_ARCHIVE_DIR"


I checked in the configure.in script and everything seems alright.  
Could someone gives me some hints about why the library is not found?

Norm


configure.in script

...
        dnl
        dnl Check OCI libraries
        dnl
        if test "$oci_header_found" = "yes"; then

            AC_MSG_CHECKING([for Oracle OCI libraries in $oracle_lib_dir])

AC_MSG_RESULT([norm:$LDFLAGS])
AC_MSG_RESULT([norm:$CPPFLAGS])

            AC_LANG_PUSH(C++)
            AC_LINK_IFELSE([
                AC_LANG_PROGRAM([[@%:@include <oci.h>]],
                    [[
OCIEnv* envh = 0;
OCIEnvCreate(&envh, OCI_DEFAULT, 0, 0, 0, 0, 0, 0);
if (envh) OCIHandleFree(envh, OCI_HTYPE_ENV);
                    ]]
                )],
                [
                ORACLE_OCI_LDFLAGS="$oci_ldflags"
                oci_lib_found="yes"
                AC_MSG_RESULT([yes])
                ],
                [
                oci_lib_found="no"
                AC_MSG_RESULT([not found])
                ]
            )
            AC_LANG_POP([C++])
        fi

        CPPFLAGS="$saved_CPPFLAGS"
        LDFLAGS="$saved_LDFLAGS"
    fi


Configure output:
...
checking for NCScbmOpenFileView in -lNCSEcw... no
checking for NCScbmOpenFileView in -lecwj2... no
checking for Kakadu JPEG2000 support... not requested.
configure: MrSID support disabled.
checking for MSG... not requested
checking for BSB... enabled
checking for Oracle OCI headers in 
/home/fgs/fgs-dev/built/instantclient_11_1/sdk/include... yes
checking for Oracle OCI libraries in 
/home/fgs/fgs-dev/built/instantclient_11_1... norm: 
-L/home/fgs/fgs-dev/built/instantclient_11_1 -lclntsh
norm: -I/home/fgs/fgs-dev/built/instantclient_11_1/sdk/include
not found
checking if Oracle support is enabled... no
checking for GRIB... enabled
checking for OGR ... enabled
checking for MySQL... yes
checking for Ingres... no
checking for Xerces C++ Parser headers in 
/home/fgs/fgs-dev/built/xerces_c/include and 
/home/fgs/fgs-dev/built/xerces_c/include/xercesc... found
checking for Xerces C++ Parser libraries... found
checking for Xerces C++ Parser... yes
checking if Xerces C++ Parser version is >= 2.7.0... yes
checking for Expat XML Parser headers in /usr/include... found
checking for Expat XML Parser libraries... found
checking for Expat XML Parser... yes
checking if Expat XML Parser version is >= 1.95.0... yes
using odbc library from /home/fgs/fgs-dev/built/unixODBC.
checking for Oracle OCI headers in 
/home/fgs/fgs-dev/built/instantclient_11_1/sdk/include... yes
checking for Oracle OCI libraries in 
/home/fgs/fgs-dev/built/instantclient_11_1... norm: 
-L/home/fgs/fgs-dev/built/instantclient_11_1 -lclntsh
norm: -I/home/fgs/fgs-dev/built/instantclient_11_1/sdk/include
not found
checking if Oracle support is enabled... no
checking Checking for DODS... disabled