> From: b...@wards.net
> Date: Sun, 4 Dec 2011 19:15:20 -0800
> Subject: Re: Maintaining simultaneous support for two Oracle versions in DBI
> To: smi...@latfor.state.ny.us
> CC: dbi-users@perl.org
>
> Aren't the Oracle driver libraries backward compatible? If you link DBD to
> the Oracle 11 drivers, won't it still be able to connect to an Oracle 8
> server?
>
No they usually only go back one version. So 9 can connect to 8~10, 10 to 9~11
ect at least that has been the trend with the last few clients at least with
OCI.
They tend to change up the OCI packaging with each new version as well just to
muck up us OCI coders.
cheers
John
> On Fri, Dec 2, 2011 at 10:27 AM, Scott Smith <smi...@latfor.state.ny.us>wrote:
>
> > My workplace is transitioning from Oracle version 9 to version 11. I would
> > like to build the DBD driver to support connecting to the Oracle 11
> > database. However, until all the data are migrated from the old database to
> > the new one, I would need to maintain connectivity to the old Oracle 9
> > database. Since the driver and shared objects built for the new database
> > would be incompatible, I would need to build separate objects for the
> > Oracle 11 connection.
> >
> > Some of the items I can identify are:
> >
> > The module should be Oracle11.pm rather than Oracle.pm (called as
> > DBI->connect("dbi:Oracle11:", ...) rather than DBI->connect("dbi:Oracle:",
> > ...)).
> > The shared object and bootstrap files as Oracle11.so and Oracle11.bs
> > respectively. (Should these go in the same directory or should they be in
> > the directory Oracle11 and does the package name in Oracle11.pm have to be
> > changed to DBD::Oracle11 in order to find things there?)
> >
> > I have some idea of what I need to change in Makefile.PL in order to
> > achieve at least part of this. What I have so far is changing references to
> > Oracle.pm to Oracle11.pm and $opts{NAME} from DBD::Oracle to Oracle 11. Am
> > I right about the second? Are there others I should have included?
> >
> > Thanks for any help,
> > Scott Smith
> >
>
>
>
> --
> Check out my LEGO blog at http://www.brickpile.com
> Follow/friend me: facebook.com/billward • flickr.com/photos/billward •
> twitter.com/williamward
