Oracle and Perl [message #163834] |
Mon, 20 March 2006 05:20 |
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 |
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
|
|
|
|
|