Re: ANNOUNCE: DBD:Oracle 1.18

[John Scoles]

When you say named parameter binding is not supported, are you talking 
about
*all* named parameters, or just for array operations?

Ohh god no!!

Just when using the execute_array();  command like this

my $sth = $dbh->prepare("INSERT INTO DETAILS ( ID,  P_ID, DATE_ENTRY) VALUES 
(:p1,:p2,:p3)") ;

$sth->bind_param_array(":p1",[EMAIL PROTECTED]);
$sth->bind_param_array(":p2",[EMAIL PROTECTED]);
$sth->bind_param_array(":p3",[EMAIL PROTECTED]);
$sth->execute_array();

Sorry if that casued you some trouble.

The real problem with execute_array and named parameter binding is that the 
native OCI does not support it very well and I wanted to get the new version 
out before I leave on summer vacation.

The plan is to add support for it with the next release some time in 
October or November.

Cheers
John Scoles
----- Original Message ----- 
From: "Steve Baldwin" <[EMAIL PROTECTED]>
To: <dbi-users@perl.org>
Sent: Tuesday, July 25, 2006 1:29 PM
Subject: RE: ANNOUNCE: DBD:Oracle 1.18


John,

When you say named parameter binding is not supported, are you talking 
about
*all* named parameters, or just for array operations?  We use named
parameters (e.g. :cust_id) extensively because it is more readable, 
position
independent, and if you are using the same parameter more than once you 
only
need to bind the value once.  Does this mean 1.18 would break our existing
code?  If so, are you expecting to rectify this behaviour - in the near
future?

Thanks,

Steve

-----Original Message-----
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 12:42 PM
To: dbi-users@perl.org; dbi-announce@perl.org; dbi-dev@perl.org
Subject: ANNOUNCE: DBD:Oracle 1.18


DBD::Oracle 1.18 has been released.

With this release DBD::Oracle finally implements Oracle's native Array
Interface.  You will see very dramatic increase in speed.
For example; the time for a 2 million plus insert query dropped from well
over an hour to less than 10 minutes when using execute_array() and the
new
code.

The new code is not 100% DBI compliant as it does not yet support named
parameter binding,but it does support all the other forms of binding and
has
full support for return Tuples.  Many thanks to Kristian Nielsen for his
original work on this code.

There is also expanded support for LOB Locators from Jeffrey Klein.

Finally there are number of little fixes and an update or two to the
readmes.

please enjoy.

John Scoles

(Please note that it may take a little while for CPAN to update to the
latest version so if you need the latest code you can always use the
subversion URL
http://svn.perl.org/modules/dbd-oracle/trunk.)