Results 1 to 6 of 6

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

  2. #2
    Join Date
    Dec 2005
    Posts
    9
    Quote Originally Posted by Erdenemandal
    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

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Installed module :
    >OS : Windows XP
    >perl : ActivePerl 5.8.6.811
    >DBD::Oracle 1.16
    >Oracle - 9.i

    From the above it is not clear to this reader if another REQUIRED component is installed or not.
    You'll also need the perl "DBI" module installed.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Dec 2005
    Posts
    9
    Thanks your Reply.

    I have installed it. DBI and DBD::Oracle (1.16).

    even it does not work.

    Regards,
    Erdene

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    The following should display the entries in the TNSNAMES.ORA file
    Code:
    use DBI;
    @data_sources = DBI->data_sources('Oracle');
    $i = 0;
    while (defined $data_sources[$i]) {
      print ("-->$data_sources[$i]\n");
      $i++;
    }
    if DBD & DBI are properly installed.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Dec 2005
    Posts
    9
    thanks, I saved your script into db.pl and called it.

    Code:
    perl db.pl
    install_driver(Oracle) failed: Can't load 'C:/usr/site/lib/auto/DBD/Oracle/Oracl
    e.dll' for module DBD::Oracle: load_file:Die angegebene Prozedur wurde nicht gef
    unden at C:/usr/lib/DynaLoader.pm line 230.
     at (eval 1) line 3
    Compilation failed in require at (eval 1) line 3.
    Perhaps a required shared library or dll isn't installed where expected
     at db.pl line 2

    I got an Error message (perl58.dll cound not found). But I think I have installed DBD::Oracle by ppm install . In this case it could be installed correctly or ?

    Regards,
    Erdene

Posting Permissions

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