Perl with Oracle 9.2

From: Christopher Grey (christopher.grey_at_hp.com)
Date: 10/14/03 

To: dbi-users@perl.org
Date: Mon, 13 Oct 2003 15:10:56 -0700

There seems to be an issue with perl when using 9.2 Oracle.
We discovered this after upgrade from 8.1.7.4 to 9.2.0.4.

Perl programs get
Unable to create database handle ERROR OCIEnvInit

I am running into a lot of cases on the net via google where
people are having the same problem with 9.2 Oracle, but no one
has a solution.
Oracle states they don't support a re-compile with 9.2 oracle,
so they are no help.
There is evidence that you need to recompile or reinstall perl
if you upgrade from oracle 8i to 9.2.0.x.

I have some one who works with me who tried to recompile and
there was a missing 9.2 library in $ORACLE_HOME/lib32.
I need to find out which.

Anyway does anyone have a solution to running perl 5.6 with
9.2.0.x oracle????

Thanks, Chris

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

Office Hp: 916-785-0783
Hp email: christopher.grey@hp.com
***************************************************

Relevant Pages

  • RE: Perl Oracle incompatibility
    ... Moreover i have not done any changes except to upgrade my Oracle ... database and nothing else. ... Subject: Perl Oracle incompatibility ...
    (perl.dbi.users)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)
  • 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: float bug? perl 5.8, DBI and oracle 10.2.0
    ... If you want to store high precision numbers in oracle, you've got 38 decimal digits to play with, and with minimal coaxing perl will handle them as strings at the appropriate points so that the exact values go in and come out. ... I haven't done any numerical work in 10 years or so, but I seem to recall that one can reasonably expect 6 or so decimal significant digits from a 32 bit floating point number - I'll go out on a limb and hazard that one can expect 12 or so digits from a 64 bit floating point number - at any rate I'd be very surprised to get 18 significant digits. ...
    (perl.dbi.users)
  • RE: Memory fault(coredump) with two DBD type connections
    ... I get a core dump ... all the libraries are the same threaded model(single threaded perl uses ... I am running Perl 5.8.8 with DBD-Oracle 1.19 compiled against Oracle ... when I try to connect to the same Oracle database AND same DB2 database ...
    (perl.dbi.users)