trouble with fresh ActiveState PPM install of DBD::Oracle

[n8]

I've been having trouble with my DBD::Oracle on Windows XP SP2 with
ActiveState Perl, so today I removed and installed Perl, DBI, and
DBD::Oracle. Same problem. Help?!

PPM installed the Oracle Instant Client and concluded:
Successfully installed DBD-Oracle version 1.17 in ActivePerl
5.8.7.815.

But this code:
perl -e "use DBD::Oracle"

produces first a popup window:

perl.exe - Entry Point Not Found
The procedure entry point Perl_Glockhook_ptr could not be located
in the dynamic link library perl58.dll.
[ OK ]

then this on the command line:

Can't load 'c:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module
DBD::Oracle: load_file:The specified procedure could not be found at
c:/Perl/lib/DynaLoader.pm line 230.
at -e line 1
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

I saw a similar popup window thread last week, about mismatched
versions of Oracle and DBD::Oracle, but my theory is that the PPM is
installing a fresh Oracle Instant Client 10.1 so it should be fine with
DBD::Oracle 1.17.

ActiveState's builds status page (
http://ppm.activestate.com/BuildStatus/5.8-D.html ) is pessimistic
about DBD::Oracle but it's the same way about a bunch of modules
including DBD::mysql which works for me.

Anyone else see this? I don't know how PPMs get built or to whom I
could talk about the build process.

[n8]

Not getting any bites from my previous request, today I tried a fresh
install of ActiveState Perl, DBI and DBD::Oracle on another Windows
machine and am getting the same results. I can't be the only one, can
I? Hello?

[sco...@pythian.com]

I would not use the ActiveState version of DBD::Oracle. T o get it to
work properly it has to be compiled with the same version to Oracle
client that is on you computer. I have no idea which oracle client was
used for the ActiveState compile so it will most likely not work

Your best would be to use the ActiveState version of DBI and compile
DBD::Oracle yourself. Follow the instructions in this file

http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.17/README.win32.txt

read the section

"Compiling and installing DBD::Oracle 1.06 on a windows 2000
professional OS"

(1.06 is a typo by the way is should read 1.17)

it should work the same way for XP except you most likely will not have
to DL and install the .net stuff

[n8]

Thanks for the reply! I'll try that (though I thought the PPM
DBD::Oracle install which downloads the Instant Client was supposed to
get around the DBD::Oracle compiled with the same compiler as the
Oracle client problem).

The annoying things are that

a) ActiveState's DBD-Oracle worked fine for me at one point

b) the README.win32.txt begins,

In general, on Windows, it's best to just use ActiveState Perl and the
PPM package manager to install a pre-built version of DBD::Oracle.

and continues later,

The preferred method of getting DBD::Oracle is to use a pre-built
version from the ActiveState repository, which can be installed with
PPM.

I wonder, is there any way to help ActiveState fix the PPM? I'd rather
spend some time doing that than building it on my machine and having to
figure it all out again next time I need it. But I don't know whom I
should contact about that... I guess I'll try asking on the ActivePerl
mailing list.

[sco...@pythian.com]

I will look into this about the readmes. I think the main problem is
number of Oracle clients that are out there now. When the Readme was
first written there was only one and PPM would work fine now there are
at least two different flavors of the Oracle client (instantClient and
Enterprise??) (not couting different versions) so perhaps PPM should
have an DBD::Oracle install for each??

[tiredofwaiting]

Hi! Did the instructions work for you? I am also facing the same issue.

Thanks!