Perl and Oracle

Erdenemandal · #1 (**permalink**) 12-16-05, 06:33

Hi, All

I have a problem with Oracle connection from PERL. When I use ODBC - it works. But when I try to connect DBI::Oracle it gives me error :

Code:

install_driver(Oracle) failed: Can't load 'C:/usr/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:Die angegebene Prozedur wurde nicht gefunden at C:/usr/lib/DynaLoader.pm line 230.
 at (eval 7) line 3
Compilation failed in require at (eval 7) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at oracletest.pl line 70

I have installed DBD::Oracle . (ppm install DBD::Oracle)

Please help me,

Erdenemandal

Installed module :

OS : Windows XP
perl : ActivePerl 5.8.6.811
DBD::Oracle 1.16
Oracle - 9.i
Edit/Delete Message

gauravjain21 · #2 (**permalink**) 01-13-06, 20:12

DBI usually works with PERL 5.6 not 5.8. to make it work with 5.8, you may need to do the following.

When running in Windows, the following registry parameters must be set to a valid value – otherwise when the program attempts to connect to the Oracle database using the Perl DBI utility, it will be rejected with a “bad NLS parameter” error message.
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0\N LS_LANG
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_LANG

All three above can be set to “AMERICAN_AMERICA.UTF8”, “AMERICAN_AMERICA.WE8MSWIN1252”, or other valid NLS_LANG value.

Internet Services

Web Development

Digital Marketing

Consumer Tech