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

On Mar 18, 2: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

Check out the PERL5LIB environment variable, as Oracle 10g creates the environment variable for DBConsole. Try setting PERL5LIB explicitly prior to executing your perl script.

HTH,
Dave Received on Wed Mar 19 2008 - 09:29:43 CDT