You have to recompile the DBD::Oracle module against your current Oracle 
version.

Mordechai


The content of this message is Applied Materials Confidential.  If you are 
not the intended recipient and have received this message in error, any 
use or distribution is prohibited.  Please notify me immediately by reply 
e-mail and delete this message from your computer system.  Thank you.







Sandeep Warikoo <sandeep_warikoo@persistent.co.in>
04/01/2005 16:50
 
        To:     richard.foley@rfi.net
        cc:     oracle-oci@perl.org
        Subject:        Re: Oracle-Perl Connection Problem
 


Hi again,

I tried NLS_LANG too. But still same result.
My database settings are:
NLS_LANGUAGE=AMERICAN
NLS_TERRITORY=AMERICA
NLS_CHARACTERSET=WE8ISO8859P1

I tried:" export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1", but still 
execution of script gave me same error.
I can connect to database through sqlplus and run queries.
I'm working on HP-UX, and database is also on an HP-UX machine.
LD_LIBRARY_PATH is also correct. :-(

We have reinstalled DBI and other related packages. But that also didn't 
work.

Regards,
Sandeep

Richard Foley wrote:

>There's a few things to look at:
>
>Sometimes you need NLS_LANG (etc.) and several others set too.
>
>LD_LIBRARY_PATH may be worth checking.
>
>Have you upgraded this Oracle recently?
>
>Can you connect using sqlplus?
>
>Don't give up - once it works, it'll work forever ;-)
>
>On Tuesday 04 January 2005 14:04, Sandeep Warikoo wrote:
> 
>
>>Hi Richards,
>>
>>Thanks for the help.
>>I have checked all the environment variables. All are correctly set
>>including TWO_TASK, ORACLE_SID, ORACLE_HOME. Still the problem persists.
>>
>>here is my modified code:
>>------------------------------------------------------------------------
>>#!/usr/bin/perl
>>
>>use DBI;
>>
>>$ENV{TWO_TASK}="d7_bilab03";
>>$ENV{ORACLE_HOME}="/data/oracle/product/9.2.0/";
>>$ENV{ORACLE_SID}="dmc";
>>
>>$dbH = DBI->connect("dbi:Oracle:","hpbi_owner","hpbi") or die 
$DBI::errstr;
>>------------------------------------------------------------------------
>>
>>d7_bilab03 is net alias for my database. It works well with tnsping. And
>>I'm able to connect to database through "sqlplus
>>hpbi_owner/hpbi@d7_bilab03"
>>
>>Sandeep
>>
>>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.
>>>> 
>>>>
>
> 
>