FAQ
Has anyone noticed if Oracle's recent patch 9.2.0.3 (SunOS 5.8 sun4u) made
it unnecessary to have a separate DBD::Oracle for Oracle 8i and for Oracle
9i client environments?

Here's a fragment that used to fail:
use Oraperl;
my $lda = &ora_login( "", "nm", "pw" );

It failed when the DBD::Oracle (admittedly a pretty old version) we used
was built with Oracle 8i client libraries,
but was run in an environment (ORACLE_HOME, LD_LIBRARY_PATH) pointing at
Oracle 9i client libraries.
At the &ora_login, $ora_errno=-1, $ora_errstr="ERROR OCIEnvInit"

We had success using the workarounds described on this list (lib->lib32,
etc. ... thanks, everyone!),
building a separate perl with a "Oracle 9i" DBD::Oracle.

But today while describing the problem to someone, I discovered that the
same code no longer fails.

I'm wondering if the culprit (ok, "hero") is our DBA's recent installation
of Oracle 9.2.0.3.
Has anyone else noticed this? It'd be nice to be able to discard that
entire extra perl....

Randy Brown

--
"NOTICE: The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential. If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected."

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedApr 9, '03 at 9:01p
activeApr 9, '03 at 9:01p
posts1
users1
websitedbi.perl.org

1 user in discussion

Randy Brown: 1 post

People

Translate

site design / logo © 2022 Grokbase