Re^3: Environmental Variables and DBD::Oracle

[valavanp]

Hi dhj, Please try this. I suggest you to give the environment variable for oracle home like below.

#!/usr/perl5/5.8.4/bin/perl -w

BEGIN
{
use lib "Your DBD Oracle module installation path";
use DBI;
use DBD::Oracle;
$ENV{"ORACLE_HOME"} ='/local/src/local.perl/oracle/instantclient_10 +_
+2';
}
my $host = "bo.boo.com";
my $sid = "AAAA";
my $user = 'secret';
my $passwd = 'evenmoresecret';

my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passw
+d) || print ("database connection not made");

$dbh->disconnect;</p>

The above code is not executed, but it works well in my server and module installation path.

Updated by Steve_p - added code tags