Re: Using Oracle's Perl tree instead of OS supplied distribution...

From: Bill Costa (Bill.Costa_at_unh.edu)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 09:51:46 -0500 (EST)
To: "dbi-users@perl.org" <dbi-users@perl.org>

     Scott <shildreth@allantgroup.com> recently wrote (in part):

> ... personally would not use it. It is perl 5.6.1. I like to stay
> more current.

     That was my first reaction too, but the sys admins and DBAs think
     that we might run into fewer problems by sticking with what
     appears to be Oracle's vetted version of Perl and DBD. My
     application is only going to talk to Oracle and will be hosted on
     a machine with Oracle installed, so it seems like a reasonable
     argument. But it's hard to say how much thought Oracle Corp
     gives to configuring their Perl distribution. And you know it is
     *always* going to be behind the curve in terms of the currently
     available Perl version.

> I looked into one of our 10.1 installs and strict.pm & English.pm
> are there, the @INC needs to be fixed.

     Yup. A problem I've seen is that with every version of Oracle it
     seems that the libraries move around. I'm wondering if @INC will
     always need to be fixed as well.

> If you want to use it, looks like it is pretty complete for a
> CGI-DBI application, set your PERL5LIB env var to point to the
> 10.1/perl dir.

     Thanks for the tips and perspective.

                                                      ...BC 

-- 
+----------------------------[ Bill.Costa@UNH.EDU ]---+
| Bill Costa                                          |
| CIS/TCS -- 1 Leavitt Lane    PHONE: +1-603-862-3056 |   No good deed...
| University of New Hampshire                         |    goes unpunished.
| Durham, NH  03824       USA                         |
|                                                     |
+-----------------[ http://pubpages.unh.edu/~wfc/ ]---+

Relevant Pages

  • Re: DBD-Oracle-1.14 and Oracle 9i
    ... > perl itself was built with the same 64bit model as Oracle wants to use. ... me it was enough to build DBI and DBD without any parameters and it ... compile fine, ...
    (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)