[DB-SIG] Transaction with DCOracle?

Eric Brunson brunson@level3.net
Mon, 5 Feb 2001 17:46:48 -0700


* M.-A. Lemburg (mal@lemburg.com) [010122 11:35]:
> 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... 

I don't think you can execute DDL though these interfaces.  At least
not with Oracle, only DML.

-- 
Eric Brunson - brunson@level3.net - page-eric@level3.net  

"When governments fear the people there is liberty. When the people
fear the government there is tyranny." - Thomas Jefferson