Certainly. See the method cursor.executemany().
On 8/3/06, Miroslav Siket <[EMAIL PROTECTED]> wrote: > Hello all, > > I was wondering if there is a way to do bulk operations with cx_Oracle - > like bulk inserts, updates,... > > Thanks, > Miro > > > On 21/07/06, Anthony Tuininga <[EMAIL PROTECTED]> wrote: > > > What is cx_Oracle? > > cx_Oracle is a Python extension module that allows access to Oracle and > conforms to the Python database API 2.0 specifications with a few > exceptions. > > > Where do I get it? > > http://starship.python.net/crew/atuining > > > What's new? > > 1) Added support for parsing an Oracle statement as requested by Patrick > Blackwill. > 2) Added support for BFILEs at the request of Matthew Cahn. > 3) Added support for binding decimal.Decimal objects to cursors. > 4) Added support for reading from NCLOBs as requested by Chris Dunscombe. > 5) Added connection attributes encoding and nencoding which return the IANA > character set name for the character set and national character set in > use > by the client. > 6) Rework module initialization to use the techniques recommended by the > Python documentation as one user was experiencing random segfaults due > to the use of the module dictionary after the initialization was > complete. > 7) Removed support for the OPT_Threading attribute. Use the threaded > keyword > when creating connections and session pools instead. > 8) Removed support for the OPT_NumbersAsStrings attribute. Use the > numbersAsStrings attribute on cursors instead. > 9) Use type long rather than type int in order to support long integers on > 64-bit machines as reported by Uwe Hoffmann. > 10) Add cursor attribute "bindarraysize" which is defaulted to 1 and is used > to determine the size of the arrays created for bind variables. > 11) Added repr() methods to provide something a little more useful than the > standard type name and memory address. > 12) Added keyword argument support to the functions that imply such in the > documentation as requested by Harald Armin Massa. > 13) Treat an empty dictionary passed through to cursor.execute() as keyword > arguments the same as if no keyword arguments were specified at all, as > requested by Fabien Grumelard. > 14) Fixed memory leak when a LOB read would fail. > 15) Set the LDFLAGS value in the environment rather than directly in the > setup.py file in order to satisfy those who wish to enable the use of > debugging symbols. > 16) Use __DATE__ and __TIME__ to determine the date and time of the build > rather than passing it through directly. > 17) Use Oracle types and add casts to reduce warnings as requested by Amaury > Forgeot d'Arc. > 18) Fixed typo in error message. > _______________________________________________ > DB-SIG maillist - DB-SIG@python.org > http://mail.python.org/mailman/listinfo/db-sig > > > > -- > Miroslav Siket CERN, IT/FIO, > CH-1211, Suisse > e-mail:[EMAIL PROTECTED] Web: http://cern.ch/mirsi > phone: +41 22 76 73068 fax: +41 22 7669859 _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
