Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client

Hello Dunston,

in my test script i set:

$ENV{ORACLE_SID}        = "ORCL";
$ENV{ORACLE_HOME}       = "/path/to/oracle/home";
$ENV{NLS_LANG}          = "AMERICAN_AMERICA.WE8DEC";
# or "GERMAN_GERMANY.WE8ISO8859P15";
$ENV{ORA_NLS}           = $ENV{ORACLE_HOME} . "/ocommon/nls/admin/data";
$ENV{PATH}              = $ENV{ORACLE_HOME} . "/bin:/usr/bin";
$ENV{LD_LIBRARY_PATH}   = $ENV{ORACLE_HOME} . "/lib";

In Oracle10 you should replace NLS_LANG by s'thing like:
$ENV{ORA_NLS10}         = '/oracle/product/10.2.0/nls/data';

cu, Christian


Dunston Rocks schrieb:
> Hi
> I had posted a few days ago about facing problems installing DBD::Oracle w
ith Oracle 10g client under Cygwin.
> Though those were circumvented successfully, when I try to run a simple sc
ript that calls DBI->Connect, I get
>
> DBI connect(....) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var
, NLS settings, permissions, etc. at tmp.pl line 12
> Error ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, perm
issions, etc. at tmp.pl line 12.
>
> ORACLE_HOME C:\oracle\product\10.2.0\client_2
> ORACLE_SID DEVDB
> TWO_TASK DEVDB
> NLS_LANG WE8ISO8859P15
>
> I saw some earlier threads on this issue which recommended ensuring that t
he permissions on ORACLE_HOME/bin and ORACLE_HOME/lib are set correctly.
> All user-accounts on this machine have "Full Control" for these directorie
s.
>
> Any recommendations anyone?
>
> Thanks
>
>
>
>
>
>
>
>        ________________________________________
____________________________
________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu0<...tDypao8Wcj9tAcJ
>