in reply to DBI support for system/application upgrades

Is a mentioned in my initial post I have already implemented a reasonably complex system using DBI/Oracle 8 and we are going to switch to Oracle 9 very soon. Do you think that these convergence's will bring issues? As far as DBI is concerned?
  • Comment on Re: DBI support for system/application upgrades

Replies are listed 'Best First'.
Re: Re: DBI support for system/application upgrades
by ehdonhon (Curate) on Apr 03, 2002 at 22:50 UTC

    The real question is wether DBD::Oracle supports it.

    From DBD::Oracle:

    <QUOTE>"DBD::Oracle is a Perl module which works with the DBI module to provide access to Oracle databases (both version 7 and 8)"</QUOTE>

    So, you might have issues if version 9 is not backwards compatable with version 8. That is, until somebody gets around to updating DBD::Oracle to be forward compatable.

      I've had no problems using DBD::Oracle (actually the DBD::Oracle8 PPD from Activestate) against a 9i database using 8i client libraries on a W2K box.

      rdfield

Re: Re: DBI support for system/application upgrades
by CukiMnstr (Deacon) on Apr 03, 2002 at 22:46 UTC
    as far as DBI is concerned, I'm pretty sure you will be ok, since DBI is a wrapper... if something gets broken, it would be DBD::Oracle. Or some non-portable SQL you may have (but since you are switching from oracle to oracle, I guess the latter shouldn't be an issue). Also, I've heard that Oracle is one of the better supported platforms in the set of DBD's, so if something breaks with oracle 9, it would be fixed quickly... another thing: oracle9 has been stable for quite a while now, so I guess they have all the bugs fixed (if they were any) in DBD::Oracle, but you should take a quick look at the changelog for the latest version of DBD::Oracle to be on the safe side.

    hope this helps,