Re: ANNOUNCE: DBD::Oracle 1.20 Release Candidate

2007-12-04 Thread Alexander V Alekseev
with this state of affairs is greatly appreciated. Thank You Rich Is this the same old problem : -- Forwarded message -- Date: Thu, 4 Oct 2007 10:27:45 -0400 From: Richard T Malafa [EMAIL PROTECTED] To: Alexander V Alekseev [EMAIL PROTECTED] Cc: Howard V Carson [EMAIL PROTECTED

Re: Issue with perl, DBD::Oracle, Solaris 10

2007-10-29 Thread Alexander V Alekseev
Hello! On Sun, 28 Oct 2007, Nicholas Veeser wrote: First, is this the right place to ask questions about compiling DBD::Oracle? I am having trouble building with DBD-Oracle 1.19 Against the stock perl in Solaris 10, I get an error that looks like this: --

Re: [patch] (final) DBD::Oracle - Support for standard array binds.

2007-10-17 Thread Alexander V Alekseev
Hello! On Fri, 14 Sep 2007, Alexander V Alekseev wrote: I strong agree with Tim's position before he teetered. Hmmm.. It seems you're right. Updated patch attached. Please, check my documentation addon. It seems to me, that it should be edited. Should

Re: patch to DBD-Oracle to allow faster fetch from REF CURSORs

2007-09-19 Thread Alexander V Alekseev
Hello! On Wed, 19 Sep 2007, Biswadeep Chowdhury wrote: This patch speeds up both the regular fetch, as well as the fetchall_arrayref(). To me that seems better than ONLY speeding up fetchall_arrayref. If application requires fast response (as typical user interface

Re: patch to DBD-Oracle to allow faster fetch from REF CURSORs

2007-09-18 Thread Alexander V Alekseev
Hello! On Tue, 18 Sep 2007, Biswadeep Chowdhury wrote: fetchall_arrayref is just as slow for REF CURSORs because internally, OCI still does a DB roundtrip for each row. Running a test will illustrate the issue. Here is a result of a test run:

Re: patch to DBD-Oracle to allow faster fetch from REF CURSORs

2007-09-14 Thread Alexander V Alekseev
Hello! On Fri, 14 Sep 2007, Biswadeep Chowdhury wrote: I am listing the patch (diff file). The REF CURSOR array-fetch can be turned on using something like $dbh-{RefCursorCacheSize}=16;. Array fetch remains off by default (single row fetch) so that it will not affect users who

Re: [patch] (final) DBD::Oracle - Support for standard array binds.

2007-09-14 Thread Alexander V Alekseev
Hello! Sorry for the late answer, I am a little busy at the moment. On Thu, 13 Sep 2007, Charles Jardine wrote: Annoyingly for me I can argue it both ways in this case. Here's a question for you: what happens when the returnd value is NULL? How can you

Re: [patch] (final) DBD::Oracle - Support for standard array binds.

2007-09-11 Thread Alexander V Alekseev
Hello! On Tue, 11 Sep 2007, Tim Bunce wrote: Hey, don't give in so easily! You can still persuade me. I'm teetering on the end. After all, you are the maintainer, you are doomed to make the choice ;-)) Anyone else have any opinions? Do any other databases support

Re: [patch] (final) DBD::Oracle - Support for standard array binds.

2007-09-11 Thread Alexander V Alekseev
Hello! On Tue, 11 Sep 2007, Alexander V Alekseev wrote: I think, the question is not of weather array types can be NULL Sorry for my english. whether of course. Bye. Alex.

Re: [patch] (final) DBD::Oracle - Support for standard array binds.

2007-09-10 Thread Alexander V Alekseev
Hello! On Mon, 10 Sep 2007, Tim Bunce wrote: On Fri, Sep 07, 2007 at 11:06:02PM +0400, Alexander V Alekseev wrote: Hello! On Fri, 7 Sep 2007, Alexander V Alekseev wrote: The final release of Oracle SYS.DBMS_SQL.VARCHAR2_TABLE

Re: [patch] (final) DBD::Oracle - Support for standard array binds.

2007-09-10 Thread Alexander V Alekseev
Hello! On Mon, 10 Sep 2007, Tim Bunce wrote: From my example: $sth-bind_param_inout(:mytable, [EMAIL PROTECTED], 10, { TYPE = DBD::Oracle::ORA_VARCHAR2, ora_maxarray_numentries = 100 } ); [TYPE is for specifying

Re: DBD [feature request] : Need to bind_param_inout array references.

2007-09-07 Thread Alexander V Alekseev
Hello! On Fri, 7 Sep 2007, Tim Bunce wrote: $sth-bind_param_inout(:mytable1, [EMAIL PROTECTED], 100, { TYPE = DBD::Oracle::ORA_VARCHAR2 } ); But autogenerated code from DBD prohibits array reference binds. void bind_param_inout(sth, param, value_ref, maxlen, attribs=Nullsv)

Re: DBD need to finish..

2007-09-07 Thread Alexander V Alekseev
Hello! On Fri, 7 Sep 2007, Richard T Malafa wrote: Hi Alexander, That may be true if I was running an Itanium 11.23 system with so instead of normal sl files. Yes HP furnishes files compilied with I suppose, so is set somewhere deep in DynaLoader just a a last

Re: [patch] DBD::Oracle - Support for array binds.

2007-09-06 Thread Alexander V Alekseev
. - Original Message - From: Alexander V Alekseev [EMAIL PROTECTED] To: dbi-dev@perl.org Sent: Wednesday, September 05, 2007 5:40 PM Subject: [patch] DBD::Oracle - Support for array binds. Hello! A preliminary version of OCI array bind patch attached. Apply to the latest trunk release

Re: Fw: [patch] DBD::Oracle - Support for array binds.

2007-09-06 Thread Alexander V Alekseev
Hello! On Thu, 6 Sep 2007, Richard T Malafa wrote: Alexander, I've gotten DBD::Oracle to pass the Makefile.PL successfully and ran the resulting make successfully. This is using DBD::Oracle 1.19, Perl 5.8.8 with DBI 1.50 in it. The compilier is GCC 4.2All of the

DBD [feature request] : Need to bind_param_inout array references.

2007-09-06 Thread Alexander V Alekseev
Hello! It would be great if I could do: $sth-bind_param_inout(:mytable1, [EMAIL PROTECTED], 100, { TYPE = DBD::Oracle::ORA_VARCHAR2 } ); But autogenerated code from DBD prohibits array reference binds. In DBD::Oracle there is an .xs file: - Oracle.xs