Oracle connection issue with perl DBI
- From: gossner92@xxxxxxxxx (Kumar Ranjan)
- Date: Wed, 19 Dec 2007 10:00:04 -0500
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
- Follow-Ups:
- Re: Oracle connection issue with perl DBI
- From: John D Groenveld
- Re: Oracle connection issue with perl DBI
- Prev by Date: Environment variable problem?
- Next by Date: RE: Environment variable problem?
- Previous by thread: Environment variable problem?
- Next by thread: Re: Oracle connection issue with perl DBI
- Index(es):
Relevant Pages
|
