Tip for DBI and DBD::Oracle on AIX 5.1 and Oracle 9.2

Thu, 14 Aug 2003 12:07:48 -0700

Here is a tip for compiling DBD::Oracle as a 32 bit application on AIX 5.1 64 bit and Oracle 9.2 64 bit without editting any makefiles. I hope people find this useful:

First, the versions of products I used:
  DBI version 1.32
  DBD::Oracle version 1.14
  Oracle 9.2.0.2 - default 64 bit application with 32 bit libraries
  AIX 5.1 ML03 - 64 bit kernel - ships with Perl as a 32 bit application.
  VisualAge C/C++ 5.0.2

Basically DBD must be compiled as 32 bit to link with Perl's 32 bit libraries.
gunzip -c DBD-Oracle-1.14.tar.gz | tar xvf –
cd DBD-Oracle-1.14
perl Makefile.PL -m $ORACLE_HOME/rdbms/demo/demo_rdbms32.mk
make

NB: I think there is a bug in the Oracle 9.2.0.3 file $ORACLE_HOME/rdbms/lib/env_rdbms.mk
I corrected this (before running the above commands) by replacing the invalid linker option
LDFLAGS32=-q32
with
LDFLAGS32=-b32

Have fun: KC.

_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger

Reply via email to