Results 1 to 2 of 2

Thread: Perl and Oracle

  1. #1
    Join Date
    Dec 2005
    Posts
    9

    Unanswered: Perl and Oracle

    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

  2. #2
    Join Date
    Mar 2005
    Posts
    41

    perl and Oracle do work using DBI

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •