Re: DBD::Oracle and bulk operations

2010-06-03 Thread Johannes Gritsch
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

Re: DBD::Oracle and bulk operations

2010-06-02 Thread John Scoles
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

DBD::Oracle and bulk operations

2010-06-02 Thread Johannes Gritsch
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