Bjorn: I intend to write a brief 'howto' with all the details on it, but in short: -use Perl 5.8.0 (the latest stable from CPAN) -use the xlc_r version of IBM's compiler and build 32 bit Perl. All tests should be successfull. -get and install DBI -get DBD::Oracle. Edit the Makefile.PL or Makefile for DBD::Oracle, changing references to Oracle's ../lib to ../lib32. and change crt0_64.o to crt0_r.o. Remove the -q32 and/or -q64 options from the list of libraries to link with. Do the make and make test. All tests should be successfull -against Oracle 9.x at least. You should have no problems with Oracle 8.1.7, but accessing Oracle 7.x or previous is not possible (you'll core dump, or simply hang). The same goes for a Linux build or a Digital build, regarding access of different Oracle versions.
I plan to try a full 64 bit build of Perl, DBI and DBD::Oracle next week, and will post results. If you try this route, per Tim Bunce's comment, disregard a DBI test fail on 03handle.pl indicating that the wrong number of bytes was returned. regards, Rafael Caceres On Wed, 2003-06-18 at 08:42, [EMAIL PROTECTED] wrote: > > Guys, I'm having the same problem atm. I have to install perl on aix 5l > system for oracle 9.2 and need to stay supported to the other versions ( > 8.1.7 ). > > So these questions : > 1. Do you guys know where the newest version for aix is located ( 5.6 on > bull website ) > > 2. Which environment needs to be set before make of Perl, DBI and > DBD:Oracle? > > 3. Which additional parameters are required > > thanks for any help you can offer > > Bjorn Naessens > > -----Original Message----- > From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] > Sent: dinsdag 17 juni 2003 14:40 > To: 'Rafael Caceres'; [EMAIL PROTECTED] > Subject: RE: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > Yes, use the 32-bit oracle libraries. I will forward a previous post on > this issue. > > > Thanks, > Sam Gold > > > -----Original Message----- > From: Rafael Caceres [mailto:[EMAIL PROTECTED] > Sent: Monday, June 16, 2003 6:54 PM > To: [EMAIL PROTECTED] > Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2 > > > Friends, I've worked with DBD::Oracle on various Linux and Digital boxes > with no problems. > I'm now trying to build DBD::Oracle on a new AIX 5.1 machine from > scratch: > Perl 5.8.0 built with xlc_r > With this perl, DBI builds and install just fine. The DBD::Oracle build > process stops with a "XCOFF64 files are not allowed in 32-bit mode". > This has to do with the fact that the OCI interface is 64bit and > libraries like crt0_64.o are included in the DBD::Oracle build. > > The problem is, if I build Perl with -Dcc=xlc_r and -q64 (to force 64 > bits), I get a problem with integer size conversions under DBI, and DBI > does not build correctly. > > Can anyone point at the 'right' combination of Perl build parameters to > enable using DBD::Oracle under AIX 5.1 with Oracle 9.2? > > Rafael Caceres > > > > >
