Kristian Nielsen [EMAIL PROTECTED] wrote: > "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?
I also don't know 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. Although I haven't used them, you can execute stored procedures using DBI / DBD::Oracle - for details, read the perldocs for DBD::Oracle. Not sure if this would solve your problem, but thought I would add it just in case :-) HTH. -- Hardy Merrill Red Hat, Inc.
