Long answer Yes with a maybe; Short answer No with a But.
All joking aside it would be a good idea to recompile DBD::Oracle when you Oracle home changes only because this usually means they (DBAs,SAs) have changed the client, Version or something else in your Oracle. So to keep everything in sync I would recompile.
That being said once DBD::Oracle is compiled is should be somewhat stand alone and not rely on the oracle client directly anymore. So changing the the Home shouldn't matter.
Cheers John Scoels RICHARD FERNANDEZ wrote:
Hello folks, A while back (months and months, in fact) I was asked to install DBI for use with an Oracle database. As part of the install I remember that I was asked for the value of things like ORACLE_HOME and some others. Today I'm told that they want to move ORACLE_HOME to someplace else on the same box. My question is: Does moving ORACLE_HOME mean that I need to recompile DBI, or was that information only used for testing during the install? I've never used it myself, so it's kind of a black box. Any hints, docs, etc would be appreciated. Thanks much. BTW, I'm not on the list, so if you could reply to this address (as well as the list, of course) I would appreciate it. Thanks! richf
