CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: DBI:
DBD::ORACLE connectivity problem



Dec 30, 2008, 4:26 AM

Post #1 of 2 (3814 views)
DBD::ORACLE connectivity problem Can't Post


I am getting below mentioned error while trying to connect DB using a perl script

install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed

Code is as follows

my $oracle_home = "/x/home/oracle/product/8.1.7";
use Env ( "ORACLE_HOME" );
$ORACLE_HOME = "$oracle_home";
use DBI;
$dbh=DBI->connect('DBI:Oracle:abcde', 'uname', 'passwd') ;

Some one please help me in solving this issue.

Veteran / Moderator

Dec 30, 2008, 6:05 AM

Post #2 of 2 (3811 views)
Re: [pra_ml] DBD::ORACLE connectivity problem [In reply to] Can't Post

You need to install the Oracle database driver module DBD::Oracle.

Your method of assigning the ENV var is wrong.

It's better style and a "Best Practice" to put your use statements, which are loaded at compile time, before any other code. And, every Perl script you write should include the warnings and strict pragmas.


use warnings;
use strict;
use DBI;

$ENV{"ORACLE_HOME"} = "/x/home/oracle/product/8.1.7";
my $dbh = DBI->connect('DBI:Oracle:abcde', 'uname', 'passwd');

(This post was edited by FishMonger on Dec 30, 2008, 6:06 AM)


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives