Re: How can I let Perl 5.6.1 and Oracle 10g work together?

On Mar 18, 8:41 am, Havel Zhang <havel.zh..._at_gmail.com> wrote:
> On Mar 18, 1:29 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
>
>
> > On Mar 18, 1:45 am, Havel Zhang <havel.zh..._at_gmail.com> wrote:
>
> > > hi all:
>
> > >          My former System using Perl 5.6.1 and Oracle 9i. Now we will
> > > migrate our oracle9i to oracle 10g. All things works fine. But I found
> > > my perl program can not compile, system will report error as follows:
> > > ===========================================================================­­­====
> > > Perl lib version (v5.8.3) doesn't match executable version (v5.6.1) at
> > > C:\oracle\product\10.2.0\db_1\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_1\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_1\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_1\perl
> > > \site\5.8.3\lib/MSWin32-x86-multi-thread/Win32/Process.pm line 4.
> > > Compilation failed in require at kill_excel.pl line 1.
> > > BEGIN failed--compilation aborted at kill_excel.pl line 1.
> > > ===========================================================================­­­====
>
> > > Any have the same issue? Any solution?
>
> > > thank you.
>
> > > Havel.Zhang
>
> > Have you tried moving the Perl 5.6.1 'home' directory before the
> > Oracle 10g directories in your PATH so that those libraries will be
> > found first?
>
> > David Fitzjarrell- Hide quoted text -
>
> > - Show quoted text -
>
> Yeah, and I tried just set PATH only to c:\Perl\bin, and the result is
> the same, So it's puzzles me:(
>
> Havel- Hide quoted text -
>
> - Show quoted text -

You may need to rebuild DBD::Oracle specifying 10g.

Check out the documentation on CPAN.

====>Patrick Received on Tue Mar 18 2008 - 11:10:09 CDT