Folks,
I am facing a funny but troubling issue with Perl DBI & Oracle.
When my shell environment does not have ORACLE_HOME path set, my script
works fine. I am connecting
to Oracle DB like this:
#!/usr/bin/perl -w
use strict;
use DBI;
my $dbh = DBI->connect("dbi:Oracle:host=xx.gold.com;port=1522;sid=sid",
$eusr, $epas,{RaiseError => 1, AutoCommit => 1})
die "Can not connect : $DBI->errstr ";
Now,
set the ORACLE_PATH to /opt/bin/oracle/9.2.0.8
and I do try to connect but it complains that it can not connect.
-Kumar R
