Re: oracle OCI.dll NLS error on connect

Sorry, but I do not remember if I had worked around this by setting NLS environment variable(s) in Windows
on each client or not. The situation was painful enough to convince me to upgrade all my (Perl) client machines to
the 9iR2 client (or technically, at least a bare minimum install to get the newer Net8 install). I haven't had any issues
accessing my 8i databases using DBD-Oracle 1.16 and the 9iR2 client.



Mitchell, Louise M wrote:

Did anyone figure this one out?  I am having the same issue, but don't
see a response to this initial posting.

I have oracle 8.1.7 client installed and the following:

Windows Server 2003
ActivePerl 5.8.7 build 813
DBI 1.49
DBD-Oracle 1.16

BTW, is anyone else having issues with PPM?  Seems like the last few
releases have had bugs.... it's getting frustrating?

L

***************

oracle OCI.dll NLS error on connect
listmail
Mon, 07 Nov 2005 09:13:55 -0800
I get the following error when connecting to an 8i oracle database from workstations with the Oracle 8i client installed or if their Oracle Home selector is set to the 8i home. If the workstations only have the Oracle 9i client installed or if the Oracle Home selector is set to the 9i home, then this error does not occur. From the looks of the error my guess is that the (unpatched?) 8i OCI.dll doesn't contain a OCINlsEnvironmentVariableGet function/subroutine.

Error dialog:
The procedure entry point OCINlsEnvironmentVariableGet could not be located in the dynamic link library OCI.dll

For those of you that may have seen this, is there a switch I can use within the DBI connect call or perhaps an environment variable that I can set within the perl code to work around this?


Windows XP and NT
ActivePerl 5.8.7 build 813 (modules installed using ppm)
DBI 1.48
DBD-Oracle 1.16




.

Relevant Pages

  • Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch wont install
    ... Currently all my Oracle inst client files are user oracle group oinstall yet lib bin and other dirs have 755 permission so root should be able to access and execute these softlibs. ... As I have written, I have installed DBD::Oracle-1.19 many times with a full client without problem, yet with the limited instant client it does not find the mk file, and the one mk file that the instant client installs does not work. ... It also gives me a makefile for DBD::Oracle but install and test fail ...
    (perl.dbi.users)
  • RE: :Oracle install problem On Solaris 8
    ... I tried to reinstall the Oracle client. ... To: Hemanth Kumar; Michael Nhan ... Subject: RE::Oracle install problem On Solaris 8 ...
    (perl.dbi.users)
  • RE: Oracle with ActiveState build 8xx
    ... > 8.1.7.4 client lib, ... I have near zero Oracle ... > libs and the OCI ... > they do install ...
    (perl.dbi.users)
  • Re: Running oracle 8 or oracle 9 on RedHat9.x
    ... > because php doesn't work with the oracle 9 client. ... But I know for sure that PHP *does* work with Oracle9 client, ... ./runInstaller again and click "Install client" or something like that. ...
    (RedHat)
  • Getting DBD::Oracle tests working
    ... Attached is the output from one install attempt. ... I'm having trouble finding your Oracle version number... ... You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version. ... all skipped: no reason given ...
    (perl.dbi.users)