[DB-SIG] Transaction with DCOracle?

M.-A. Lemburg mal@lemburg.com
Mon, 22 Jan 2001 19:28:48 +0100


Peter Sabaini wrote:
> 
> i do something like
> 
> ----------------
> from DCOracle import Connect, error
> try: cursor.somedangerous_sql()
> except error, detail: cursor.rollback()
> ----------------

A general warning on this kind of approach: not all SQL
commands can be rolled back, e.g. dropping a table is not
necessarily reversable... 

-- 
Marc-Andre Lemburg
______________________________________________________________________
Company:                                        http://www.egenix.com/
Consulting:                                    http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/