"Konigsberg, Jay" <[EMAIL PROTECTED]> writes: > Hi all, > > The Perl DBI doesn't support INSERT, or UPDATE cursors, which is a pity, because > they can dramatically reduce the time it takes for many programs to run.
Could you briefly explain what an INSERT/UPDATE cursor is? Using DBD::Oracle, if you $dbh->prepare() an insert or update statement, the DBI holds an open cursor in the database for the statement, allowing multiple fast calls to $sth->execute() all using the open cursor. Presumably this is not what you have in mind? For fast insert, Oracle supports array execution where multiple sets of bind variables are passed in a single execute (for example to insert many rows in a single execute). Is this what you have in mind? I believe a few DBD's support array execution (using $sth->execute_array(). DBD::Oracle doesn't, but I posted a patch to [EMAIL PROTECTED] a few months back. There was no interest at the time, though I do expect to clean it up and get it into the official DBD::Oracle eventually. - Kristian. -- Kristian Nielsen [EMAIL PROTECTED] Development Manager, Sifira A/S
