Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)

Hi!

> > > There's a newer linux-oracle-instantclient-sdk available in the
> > > ports (10.2.0.3), and maybe it helps to compile and link a newer
> > > DBD::Oracle.
> > 
> > I have that one (actually, those three), but they are nine
> > years old as well: 20061115_5 is coded into the ports name.
> 
> The API did not change that much, so I guess it might work to use 10.2.0.3
> to update the DBD::Oracle port to 1.74.
> 
> I'm currently upgrading my test host from perl5.20 to perl5.22, so it
> will take some time until I can experiment with 1.74.

It looks promising, but:

The FreeBSD ld does not like the SYSV shared lib to link with:

LD_RUN_PATH="/compat/linux/usr/lib/oracle/10.2.0.3/client/lib" cc  -shared  -L/usr/ports/lang/perl5.22/work/perl-5.22.0 -L/usr/local/lib/perl5/5.22/mach/CORE -Wl,-rpath=/usr/local/lib/perl5/5.22/mach/CORE -lperl -L/usr/local/lib -fstack-protector Oracle.o  dbdimp.o  oci8.o  -o blib/arch/auto/DBD/Oracle/Oracle.so        -L/compat/linux/usr/lib/oracle/10.2.0.3/client/lib -L/usr/local/home/pi/myp/databases/p5-DBD-Oracle/work/DBD-Oracle-1.74/../.. -locci -lclntsh -lpthread       
/usr/bin/ld: skipping incompatible /compat/linux/usr/lib/oracle/10.2.0.3/client/lib/libocci.so when searching for -locci
/usr/bin/ld: cannot find -locci
cc: error: linker command failed with exit code 1 (use -v to see invocation)

file /compat/linux/usr/lib/oracle/10.2.0.3/client/lib/libocci.so

libocci.so.10.1: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), dynamically linked, not stripped

and I do not have a non-shared lib to link against. Any ideas ?

Can a SYSV shared lib be transformed into some other shlib ?

-- 
[email protected]            +49 171 3101372                         5 years to go !