connect to Oracle 10g with Perl

[jablonsky]

hi all,
my question is how to connect to Oracle 10g with Perl.

my perl installation is: Perl 5.8.6.811 and I have installed DBI 1.58 and DBD-Oracle 1.17

I have installed Oracle 10g Client 10.2.0 and I am trying to access a 10g 10.2 server.

Right now I am getting a strange message when I try to execute this code:
#############################
#!/usr/bin/perl
use strict;

use DBI;

print "before connection!\n";

my $usr = "user";
my $pwd = "pass";

my $dbh = DBI->connect("dbi:Oraclercl_192.168.55.116", $usr, $pwd) || die "DB connection not established: $DBI::errstr";

print "after connection!\n";

##################################
I checked the connection - I can connect with all mgmgt tools from my location, with SQL*Plus, the service is orcl_192.168.55.116 , user is correct, password is correct.

The first error is:
The procedure entry point Perl_Glockhook_ptr could not be located in the dynamic link library perl58.dll
After I click the OK button in this error window the message in my DOS window is:
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file: The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230 at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected at C:\perl_dev\oracle\con1.pl line 10
and then it prints before connection!

I know there should be an alternative ODBC connection, nevertheless I would like to see if I can fix this first.
Anybody any idea?

Thanks,
jablonsky

 

[MikeLacey]

Hi jablonsky,

This looks like an error with your DBI and or DBD installation. I'd be going through the installation procedure again, carefully looking at all of the output. I've not used the DBI in a while - are there test routines you can use to check your installation? (there used to be)

Mike

When working on any project the value of other people is exactly that - they are other people, with views that don't necessarily match yours. This mismatch, between their views and the view you've been contentedly assuming is right, is where that value lies.