"Jia Lu" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all. > I use cx_Oracle to connect to an Oracle9i DB. And I want to turn on > AUTOCOMMIT function. > I see that cur.execute("SET AUTOCOMMIT ON") cannot work. Is there any > method to do that ?? > > Thanks a lot! > AUTOCOMMIT is a dangerous crutch, beware. Ok for single record updates, but if you need to update 2 records in synch, AUTOCOMMIT leaves you open to hard-to-debug bugs (will work ok in development under light load, then fail intermittently with concurrent users).
-- Paul -- http://mail.python.org/mailman/listinfo/python-list