Re: ANNOUNCE: DBD:Oracle 1.18

> 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",\@pd_id);
$sth->bind_param_array(":p2",\@p_id);
$sth->bind_param_array(":p3",\@date_entry);
$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"
To:
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:scoles@pythian.com]
>> 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.)
>>
>
>
>
>