DBD::ORACLE Question

kprasanna_79 has asked for the wisdom of the Perl Monks concerning the following question:

Revered Monks,

I was using oracle 9.0.1 in UNIX with DBD::Oracle & DBI installed. Every thing was working fine. Now i want to use Oracle 9.2.0 with the same Settings. Should i recomplie the DBD::Oracle against this new database.

Because the Oracle_home path was not set to 9.2.0 even when i set that manually in the .profile.

But this works fine when i hard code the path in script. $ENV{'ORACLE_HOME'}='/oracle/product/9.2.0';

Please advice
-Prasanna.K

Comment on DBD::ORACLE Question

Replies are listed 'Best First'.
Re: DBD::ORACLE Question by tuxz0r (Pilgrim) on Nov 01, 2007 at 18:30 UTC
I think it's a good idea to recompile the module against the new 9.2.0 database code. Yes, technically the API DBD::Oracle uses might be stable and backward compatible and you might just be able to set `$ORACLE_HOME`; but, moving from 9.0 to a 9.2 minor version is bound to affect you somewhere down the line. I'd recompile in ALL cases, since it never hurts and can only help if the API has added more features, enhancements or bug fixes. --- echo S 1 [ Y V U \| perl -ane 'print reverse map { $_ = chr(ord($_)-1) } @F;'	[reply]
Re: DBD::ORACLE Question by KurtSchwind (Chaplain) on Nov 01, 2007 at 18:35 UTC
You only need to recompile if you intend to use the newer client. You could continue to use the previous client against the new database with no ill affects. While it's true that there is no harm in re-compiling, you can skip it if you don't intend on using a new client. -- I used to drive a Heisenbergmobile, but everyone I looked at the speedometer, I got lost.	[reply]