ActiveState Community

Perl 5.10 and Oracle 10g

Posted by Andrey999 on 2008-12-16 13:44
OS: Windows Server 2003

I'm trying to connect to Oracle 10g from Perl 5.10 (latest version available), I'm getting the following error:

Perl lib version (v5.8.3) doesn't match executable version (v5.10.0) at C:\oracle\product\10.2.0\db_3\perl\5.8.3\lib/MSWin32-x86-multi-thread/Config.pm line 32.
Compilation failed in require at C:\oracle\product\10.2.0\db_3\perl\5.8.3\lib/MSWin32-x86-multi-thread/DynaLoader.pm line 25.
BEGIN failed--compilation aborted at C:\oracle\product\10.2.0\db_3\perl\5.8.3\lib/MSWin32-x86-multi-thread/DynaLoader.pm line 25.
Compilation failed in require at C:\oracle\product\10.2.0\db_3\perl\site\5.8.3\lib/MSWin32-x86-multi-thread/DBI.pm line 156.
BEGIN failed--compilation aborted at C:\oracle\product\10.2.0\db_3\perl\site\5.8.3\lib/MSWin32-x86-multi-thread/DBI.pm line 156.
Compilation failed in require at parse835.pl line 3.
BEGIN failed--compilation aborted at parse835.pl line 3.

Any ideas of how get it to work?

Have you found an answer to
Daniel Saltman | Thu, 2008-12-18 15:54

Have you found an answer to this yet?
Thanks

Daniel Saltman
BostonDan@gmail.com

Perl 5.10 and Oracle 10g
rex.arul | Fri, 2008-12-19 12:36

You claim that you have 5.10. However, the Oracle 10g installation also has a Perl that is of version 5.8.3.

Oracle's bundled Perl v 5.8.3 does not have any of the modules you are trying to use: viz., DBI and DBD::Perl.

Modify your path information so that your Perl v 5.10 takes precedence. You may also need to modify the PERL5LIB variable in the list of environmental variables. Take a look here:

http://community.activestate.com/forum/oracle-10g-install-xp-home-causin...

A word of caution -- Caveat emptor -- here. That is, DBD::Oracle may not work well with Perl 5.10 as I have seen many plaints in this regard. I haven't personally tested this, but try installing DBD::Oracle under Perl 5.10, of course after you change the path information.

Re:
ellison | Wed, 2009-10-07 22:26

I don't know about the topic but I'm sure that you are the correct place.You will definitely get the desired answer of your problem.I would also recommend a book on OLAP and believe me its pretty informative.
The book is available on Amazon at http://www.amazon.com/Multidimensional-Data-Modeling-Toolkit-Intelligenc... & you can buy an e-book directly from the publisher by writing OLAPWorldPress@gmail.com.