[DB-SIG] Transaction with DCOracle?

Eric Brunson brunson@level3.net
Mon, 5 Feb 2001 18:08:39 -0700


* Eric Brunson (brunson@level3.net) [010205 17:52]:
> * 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.
> 


Well, the DCOracle2 docs prove me wrong.  Never mind

*wipes egg from face*

e.

-- 
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