RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
A final note on this. Seems there was a very very long unknown bug in DBI which was only fix a few days ago wiht DB 1.6.31 http://blogs.perl.org/mt/mt.fcgi?__mode=view_type=entryid=5570blog_id=2165 The end result of this bug was that when callbacks are used on the statement handle

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread Tim Bunce
On Fri, Jan 31, 2014 at 09:11:28AM -0500, John Scoles wrote: A final note on this. Seems there was a very very long unknown bug in DBI which was only fix a few days ago wiht DB 1.6.31 If you mean Callbacks getting an inner handle, that wasn't a bug as such. More like a design choice

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread Martin J. Evans
On 31/01/14 16:21, Tim Bunce wrote: On Fri, Jan 31, 2014 at 09:11:28AM -0500, John Scoles wrote: A final note on this. Seems there was a very very long unknown bug in DBI which was only fix a few days ago wiht DB 1.6.31 If you mean Callbacks getting an inner handle, that wasn't a

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
Well I did do some testing. The leak was very small (1k over 10 min run) but only when one does $shift-FETCH( 'ParamValues' ), in the child callback. Tim what would the impact of the above?? I know before 1.63 this $shift-{ParamValues'}, gave you undef which is why the WTF

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread Tim Bunce
On Fri, Jan 31, 2014 at 12:50:36PM -0500, John Scoles wrote: Well I did do some testing. The leak was very small (1k over 10 min run) but only when one does $shift-FETCH( 'ParamValues' ), in the child callback. If it doesn't keep growing with more call then it's not a leak. Tim

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
Date: Fri, 31 Jan 2014 22:09:02 + From: tim.bu...@pobox.com To: byter...@hotmail.com CC: martin.ev...@easysoft.com; tim.bu...@pobox.com; hhferre...@gmail.com; boh...@ntlworld.com; dbi-users@perl.org Subject: Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE) On Fri,

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
From: byter...@hotmail.com To: tim.bu...@pobox.com CC: martin.ev...@easysoft.com; hhferre...@gmail.com; dbi-users@perl.org Subject: RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE) Date: Fri, 31 Jan 2014 18:04:44 -0500 Opp hit send too fast Date: Fri, 31 Jan 2014