Thank you, this is exactly what I was looking for.
best wishes
hannes
On 06/02/2010 02:31 PM, John Scoles wrote:
Johannes Gritsch wrote:
DBI does support bulk operations and what you are asking about is the
array interface.
It does it though the 'execute_array'
http://search.cpan.org/~timb/DB
Johannes Gritsch wrote:
DBI does support bulk operations and what you are asking about is the
array interface.
It does it though the 'execute_array'
http://search.cpan.org/~timb/DBI-1.611/DBI.pm#execute_array method.
and it is available to all DBD drivers.
DBD::Oracle is special as it imp
Hi!
Since I came into this topic while writing a script: What does
DBD::Oracle know about bulk operations?
In PL/SQL you can speed up your cursor loops by using bulk fetches
and/or bulk updates/inserts. Instead of operating on single rows you use
arrays of rows. Since DBI does not support it