Hi Karl
I finally uncovered the issue here.
Seems you are right is is a bug of sorts.
Looks like I was dropping the environment handle when I should of been
keeping it in the situation where it is just a login issue.
You will find the corrected code here
I'm experiencing a very strange problem : in short, I could not reconnect
to a DB using DBI once I successfully connected then failed (with bad
password for example), IN THAT ORDER.
I made a script reproducing the bug:
=
#!/usr/bin/env perl
use strict;
use warnings;
use DBI;
my
Karl Forner wrote:
I'm experiencing a very strange problem : in short, I could not reconnect
to a DB using DBI once I successfully connected then failed (with bad
password for example), IN THAT ORDER.
I made a script reproducing the bug:
=
#!/usr/bin/env perl
use strict;
use
On Thu, Feb 19, 2009 at 12:33 PM, Martin Evans martin.ev...@easysoft.comwrote:
Karl Forner wrote:
I'm experiencing a very strange problem : in short, I could not reconnect
to a DB using DBI once I successfully connected then failed (with bad
password for example), IN THAT ORDER.
I made a
What is the version of the Oracle client you are using?
There is a rather large gap between 1.16 and 1.22 on the way they connect
especially with the older Oracle clients which could explain his
cheers
John Scoles
On Thu, Feb 19, 2009 at 12:33 PM, Martin Evans
martin.ev...@easysoft.comwrote:
oracle instant client 11.1
But it seems to work now using the 'ora_envhp = 0' attribute. Is there some
penalty performance when using this option ?
On Thu, Feb 19, 2009 at 1:56 PM, sco...@pythian.com wrote:
What is the version of the Oracle client you are using?
There is a rather large gap
oracle instant client 11.1
I wonder if they have changed how 11.1 works?? wil have to look at that
what was the ORacle version working with 1.16?
But it seems to work now using the 'ora_envhp = 0' attribute. Is there
some
penalty performance when using this option ?
Not in terms of speed
On Thu, Feb 19, 2009 at 2:08 PM, sco...@pythian.com wrote:
oracle instant client 11.1
I wonder if they have changed how 11.1 works?? wil have to look at that
what was the ORacle version working with 1.16?
9.2.0
But it seems to work now using the 'ora_envhp = 0' attribute. Is
On Thu, Feb 19, 2009 at 2:08 PM, sco...@pythian.com wrote:
oracle instant client 11.1
I wonder if they have changed how 11.1 works?? wil have to look at that
what was the ORacle version working with 1.16?
9.2.0
Ok that would explain it. This older client would use a now depricated