Re: possible bug in DBI with DBD::Oracle

2009-02-23 Thread John Scoles
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

possible bug in DBI with DBD::Oracle

2009-02-19 Thread Karl Forner
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

Re: possible bug in DBI with DBD::Oracle

2009-02-19 Thread Martin Evans
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

Re: possible bug in DBI with DBD::Oracle

2009-02-19 Thread Karl Forner
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

Re: possible bug in DBI with DBD::Oracle

2009-02-19 Thread scoles
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:

Re: possible bug in DBI with DBD::Oracle

2009-02-19 Thread Karl Forner
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

Re: possible bug in DBI with DBD::Oracle

2009-02-19 Thread scoles
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

Re: possible bug in DBI with DBD::Oracle

2009-02-19 Thread Karl Forner
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

Re: possible bug in DBI with DBD::Oracle

2009-02-19 Thread scoles
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