[gdal-dev] Problem Compiling with Oracle (--with-oci)

[Chris Hodgson]

I'm trying to compile GDAL/OGR with support for Oracle/OCI. I have the 
full oracle 11g server installed on CentOS 5.3.

# configure --with-oci=/opt/oracle/product/11.2.0/dbhome_1/
# make
...
libtool:.....
g++: /ade/smayer_perl_510/perl_source/expat_home/lib/libexpat.so: No 
such file or directory

I think this path might be from the person who compiled the OCI 
libraries for oracle 11? I have nothing remotely like it on my system. 
If I add --with-expat=no to my configure line I get errors during 
linking about undefined references to XML_... so I'm guessing the linked 
OCI drivers need the expat lib linked in.

I added /opt/oracle/product/11.2.0/dbhome_1/lib to my LD_LIBRARY_PATH, 
and there is a libexpat.so.1.5.2 there, as well as my 
/lib/libexpat.so.0.5.0 which is from my CentOS standarad RPMS:

# rpm -qa | grep expat
expat-1.95.8-8.2.1
expat-devel-1.95.8-8.2.1

I also tried --with-expat=/opt/oracle/product/11.2.0/dbhome_1/ but there 
are no headers there, among other problems.

How can I get this to work?

Thanks,
Chris