Re: Oracle-Perl Connection Problem

Also, this should be on the dbi-users list.  Join that list for
DBI/DBD Questions.

On Tue, 2005-01-04 at 12:09 +0100, Richard Foley wrote:
> You usually need to have quite a few environment variables set before you can 
> access Oracle, as the error message (OCIEnvInit) roughly indicates.  Try 
> reading the docs that came with the DBI (and DBD::Oracle particularly), I 
> believe there are many examples in there.
> 
> You are at least short of 
> 
> 	ORACLE_SID or TWO_TASK
> 
> Ciao
> Richard Foley
> ---
> Ciao - Shorter than Aufwiedersehen
> 
> http://www.oreilly.com/catalog/perldebugpr/index.html
> 
> On Tuesday 04 January 2005 09:47, Sandeep Warikoo wrote:
> > Hi,
> >
> > I'm trying the access oracle through perl, but am getting the error
> > "ERROR OCIEnvInit".
> >
> > My perl script is:
> >
> > -------------------------------------------------------------------------
> > use DBI;
> >
> > $ENV{ORACLE_HOME}='/data/oracle/product/9.2.0';
> >
> > my $dbh = DBI->connect("dbi:Oracle:d7_bilab03","hpbi_owner","hpbi") or
> > die "couldn't connect to database:    $DBI::errstr\n";
> >
> > --------------------------------------------------------------------------
> >
> > Does anyone know how to solve this?
> >
> > Regards,
> > Sandeep W.
> 
-- 
Scott T. Hildreth <[email protected]>