On Thu, Dec 13, 2007 at 01:20:38AM +0300, Alexander V Alekseev wrote: > On Wed, 12 Dec 2007, Loo, Peter # PHX wrote: > > > > Hi Martin, > > > > I tried setting both variables at the very beginning before any > > connection is made and the result is still the same. > > > > $ENV{ora_envhp} = 0; > > $ENV{ORA_ENVHP} = 0; > > ora_envhp is one of "Connect Attributes" (as stated in perldoc > DBD::Oracle). Therefore it must be passed to DBI->connect() call like this: > > my $dbh = DBI->connect($dsn, $user, $password, > { RaiseError => 0, AutoCommit => 0, ora_envhp=> 0 });
As documented in the fine manual. Tim. http://www.catb.org/~esr/faqs/smart-questions.html