Second Request: Link Fails with Personal Oracle8 and DBD-Oracle-1.15

From: David (cupcake_at_sdf.lonestar.org)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 15:01:00 -0400 (EDT)
To: dbi-users@perl.org

Hi,

I have oracle 8 personal edition with OCI80 installed on WinNT.

I have DBD-Oracle-1.15 and running in cygwin downloaded in the last
90 days. I also tried versions 7 through 14.

perl Makefile.PL can't find the Oracle version number. Not a problem,
apparently. But, LobWriteAppend is in an ifdef for V8_SYNTAX.
Dropping V8_SYNTAX creates even more problems.

If I comment out OCILobWriteAppend, then the database updates don't work.
Can you please help me fix this. Thanks.

make (-f Makefile) generates the following.

David
p.s. Please also reply to cupcake@sdf.lonestar.org

 
gcc -c -IC://sys//ora8p/OCI80/include -IC://sys//ora8p/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE" -DUTF8_SUPPORT Oracle.c
gcc -c -IC://sys//ora8p/OCI80/include -IC://sys//ora8p/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE" -DUTF8_SUPPORT dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:307: warning: cast to pointer from integer of different size
dbdimp.c:317: warning: cast to pointer from integer of different size
dbdimp.c:321: warning: cast to pointer from integer of different size
dbdimp.c:325: warning: cast to pointer from integer of different size
dbdimp.c: In function `dbd_rebind_ph_char':
dbdimp.c:1145: warning: cast from pointer to integer of different size
gcc -c -IC://sys//ora8p/OCI80/include -IC://sys//ora8p/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE" -DUTF8_SUPPORT oci7.c
gcc -c -IC://sys//ora8p/OCI80/include -IC://sys//ora8p/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE" -DUTF8_SUPPORT oci8.c
rm -f blib/arch/auto/DBD/Oracle/Oracle.dll
LD_RUN_PATH="C://sys//ora8p/lib:C://sys//ora8p/rdbms/lib" ld2 -s -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.dll /usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE/libperl.dll.a -L/DBD-Oracle-1.15 -loci
gcc -shared -o Oracle.dll -Wl,--out-implib=libOracle.dll.a -Wl,--export-all-symbols -Wl,--enable-auto-import -Wl,--stack,8388608 \
-s -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o /usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE/libperl.dll.a -L/DBD-Oracle-1.15 -loci
Creating library file: libOracle.dll.a

Oracle.o(.text+0x79a1):Oracle.c: undefined reference to `_OCILobWriteAppend'

collect2: ld returned 1 exit status
perlld: *** system() failed to execute
gcc -shared -o Oracle.dll -Wl,--out-implib=libOracle.dll.a -Wl,--export-all-symbols -Wl,--enable-auto-import -Wl,--stack,8388608 \
-s -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o /usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE/libperl.dll.a -L/DBD-Oracle-1.15 -loci

make: *** [blib/arch/auto/DBD/Oracle/Oracle.dll] Error 1

Relevant Pages