Re: DBD-Oracle and Oracle versions
- From: scoles@xxxxxxxxxxx (John Scoles)
- Date: Wed, 20 Dec 2006 07:00:46 -0500
""Capacio, Paula J"" <PCAPACIO@xxxxxxxxx> wrote in message
news:A787F31512A25E4F9782045CFE320C800F894CF3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
From lurking around this mail list over the years,I've seen numerous items relating to building
DBD-Oracle against a specific version of the Oracle
client software on *nix systems.
Natrue of the beast. DBD::Oracle uses OIC which is part of the Oracle
client so you change you client you have to rebuild your DBD::Oracle
Example: if DBD-Oracle was built using version 9,
then the Oracle client is upgraded to 10g;
it is necessary to rebuild DBD-Oracle with the 10g client.
Well you could keep you 9 client and still connect to 10g with it. The DB
would not care that much. You might miss out on any new features that 10g
introduced though.
I have used Perl on HP/UNIX, AIX, Linux and Windows.
On the *nix systems, Perl came with the OS and I have
had to install the DBI and DBD-Oracle modules using
the standard make process. On windows, I used
ActiveState Active Perl and PPM to install DBI and
DBD-Oracle modules. In the windows environment I
never have to worry about which version of the Oracle
client is present and I can upgrade to a different
client version of Oracle without having to reinstall
the DBD-Oracle module.
Well what happens here is that Active State does the DBD::Oracle compile
perl for you and you just down load the whole thing, compiled code Oracle
client and perl code and then it points you perl to it. In this case your
DDB::Oracle is still using the versioin of the client it was compiled with
so you might have see some isuese say if you were using bulk inserts with
the array interface. Lets say a million records, You may have ActiveState
DBD:Oracle 1.17 installed this operation would take at least half a hour
plus. If you recompiled your DBD::Oracle to 1.18 or later this operation may
only take a few mins.
What trick allows PPM modules to work regardless of
Oracle client versions? Ultimately, I'd like to know
if there is a way to 'make' the modules on *nix systems
so that they don't rely on a specific version?
We would have to percompile and bundle the binaries with the PPM one PPM for
each version of the Oracle client. One however runs into problems with
copyright. Oracle has only given public redistribution permission for the
10g instantclient binarys not its other client products.
hope this clears a few things up.
Thanks in advance,
Paula
.
- References:
- DBD-Oracle and Oracle versions
- From: Paula J Capacio
- DBD-Oracle and Oracle versions
- Prev by Date: Re: Would you please do me a favor?
- Next by Date: RE: DBD-Oracle and Oracle versions
- Previous by thread: RE: DBD-Oracle and Oracle versions
- Next by thread: RE: DBD-Oracle and Oracle versions
- Index(es):
Relevant Pages
|
