RE: Connect to Oracle



You should always include information about your platform, Perl version,
DBD::Oracle version and Oracle version, as it almost always helps with the
answer. Here are some guesses:

You mention OCI.dll, so that's Windows.

It's getting as far as loading the libraries, so you have an Oracle client
installed.

You've got DBD::Oracle installed, but it doesn't work, which implies the
test suite wasn't run on installation. So you've probably installed a binary
distribution of DBD::Oracle using PPM into ActiveState Perl?

It's complaining about OCINlsEnvironmentVariableGet which was added on
Oracle 9i, so I'm guessing you have installed a binary distribution of
DBD::Oracle that was compiled against 9i or 10g, but you have an Oracle 8i
client installed.

You could recompile DBD::Oracle against 8i if you have the Microsoft C
compiler, but since 8i is no longer supported by Oracle then you'd probably
be better off upgrading to 9i or 10g - at least on the client.

--
Andy Hassall :: andy@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

-----Original Message-----
From: Angela Chan [mailto:achan90@xxxxxxxxx]
Sent: 27 February 2006 19:56
To: dbi-users@xxxxxxxx
Subject: Connect to Oracle

Hi,

I just install DBD::ORACLE in PERL, and try to connect to my
ORACLE DB.
However, I receive the following error message. Does anyone
know how to
resolve this problem? Thanks

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

Angela


.



Relevant Pages

  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... On the premise instant client and also tried to run perl Makefile.PL -V ... the status after having connected to Oracle ... Failed 2/33 tests, 93.94% okay ...
    (perl.dbi.users)
  • Re: Oracle client not found ...- vb.net
    ... I believe clients tools come as a separate installation for Oracle ... > Oracle client and networking components were not found. ... > o, Type objType, String name, Objectargs, Stringparamnames, ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Accessing oracle from windows 2000
    ... platforms (with caveats and issues that will be outlined below. ... I use DBD::Oracle when using an Oracle data source. ... You need to have the Oracle client installed -- and licensed -- on your ... while ago (after the Perl 5.6.x timeframe and before 5.8.x timeframe). ...
    (perl.dbi.users)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)
  • Re: Oracle client and vs studio 2003 and vb code
    ... setup on other machines where I have installed the Oracle 9i client, ... Oracle Version 7.3.3 or later client software installation. ...
    (comp.databases.oracle.misc)