Re: Problem with perl 5.8.8 with Oracle 9.0

Are you using ActiveState Perl on Windows? Looks like Windows from
your f: path.

I had trouble a month or so ago because the new PPM DBD-Oracle module
installs the Oracle Instant Client, which seems to behave differently
than the old full client I had.

I found an answer (
http://groups.google.com/group/perl.dbi.users/browse_frm/thread/cd04e4bd8f04d122/c60a56488a6a08b9
) about setting the NLS_LANG environment variable to "American" but
I wanted a more global solution. The Instant Client FAQ (
http://www.oracle.com/technology/tech/oci/instantclient/ic-faq.html )
helped me out - I had to update NLS_LANG in the registry in
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

Hope that helps. I don't understand how the link to the thread
culminating in the advice "DBD::Oracle no longer works with Oracle 8'
applies to your situation since you said you're using Oracle 9...

-n

Kedar Joshi -X wrote:
Hi Tim,
I have a problem with perl operating with DBD-Oracle. The error i get is
as follows -

DBI connect('edwtest','i2_read',...) failed: ERROR
OCINlsEnvironmentVariableGet(
OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscrip
t\perlscript\i2lutils.pl line 2372
Database connection not made: ERROR
OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET
_ID) Check ORACLE_HOME and NLS settings etc. at
f:\tkprod\bkscript\perlscript\i2
lutils.pl line 2372.
[i2csync.bat] Csync failed, check i2csync.out

Please help. I feel this might be a problem with Oracle installation. So
first question is which version of Perl is compatible with Oracle 9.0?
With Best Regards

Kedar Joshi
i2 Demand Planner Upgrade
CISCO ODC, 1st Floor, Building 2, Infosys Technologies Limited,
Bangalore.
Phone No - 08051167206
Mobile - +91 9980453162


------_=_NextPart_001_01C64F26.3D17743E--

.

Relevant Pages

  • Re: Oracle error with swedish characters
    ... i have the problem running perl to oracle on linux only. ... machine was just a test to see if it was a greater perl problem. ... works on windows i am now trying to get perl DBI to work only on linux. ... > oracle the character mentioned is ascii 229. ...
    (perl.dbi.users)
  • Re: Oracle error with swedish characters
    ... > machine was just a test to see if it was a greater perl problem. ... > works on windows i am now trying to get perl DBI to work only on linux. ... what you want to use in the system configuration, and also in the Oracle 8.1.7. ...
    (perl.dbi.users)
  • Ref : RE: Help needed for DBD-Oracle Installation in Windows 2003
    ... DBD::Oracle is OK with perl 5.6. ... Objet: RE: Help needed for DBD-Oracle Installation in Windows 2003 ... layer to get to Oracle. ...
    (perl.dbi.users)
  • Re: Tool Like TOAD
    ... > Is there a tool like TOAD that I can use with PERL on Windows XP ... You mean "Tool for Oracle Application Developers"? ... Perl scripts like you use TOAD to edit PL/SQL? ...
    (perl.beginners)
  • Re: GUI and Rapid Application Development?
    ... Most simple applications that I dealt with did not need the use of API ... I imagine Perl is faster, ... my Perl scripts are more compact ... Chirag> in Windows that could run on Windows 98 through 2003. ...
    (comp.os.linux.misc)