Home » Open Source » Programming Interfaces » Oracle and Perl
Oracle and Perl [message #163834] Mon, 20 March 2006 05:20 Go to next message
thomas777neo
Messages: 6
Registered: March 2006
Junior Member
Apologies if this post is in the incorrect place, I couldn't find an appropriate section for it.

Well here goes, I have an issue connecting to an oracle database using perl. Here is the error msg:

test.pl
use strict;
use DBI;
         
my $dbh = DBI->connect( 'dbi:Oracle:orcl', 'scott', 'tiger',
                      { RaiseError => 1, AutoCommit => 0 }
                      ) || die "Database connection not made: $DBI::errstr";
$dbh->disconnect;


windows error
Quote:

the procedure entry point PL_memory_wrap could not be located in the dynamic link library perl58.dll


perl error
Quote:

install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Orac
le.dll' for module DBD::Oracle: load_file:The specified procedure could not be f
ound at C:/Perl/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 C:\test_connection.pl line 3


If anybody knows how to resolve this issue it would be much appreciated.

Thanks
Re: Oracle and Perl [message #163925 is a reply to message #163834] Mon, 20 March 2006 17:56 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You have installed Perl module DBI, but did you also install DBD::Oracle? DBI just gives you the common interface, you need the specific database DBD module to do the hard work of talking to the database.
_____________
Ross Leishman
Re: Oracle and Perl [message #164344 is a reply to message #163925] Thu, 23 March 2006 01:26 Go to previous messageGo to next message
thomas777neo
Messages: 6
Registered: March 2006
Junior Member
I have installed it, yet it still gives me the error
Re: Oracle and Perl [message #164529 is a reply to message #164344] Thu, 23 March 2006 20:44 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
What do you have in 'C:/Perl/site/lib/auto/DBD/'?
Previous Topic: Creating oracle tables through PHP/HTML
Next Topic: ORACLE - PHP Issue
Goto Forum:
  


Current Time: Thu Mar 28 11:43:56 CDT 2024