in reply to
Re^2: Environmental Variables and DBD::Oracle
in thread Environmental Variables and DBD::Oracle
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
