[DB-SIG] DCOracle2 in auto-commit mode ?

M.-A. Lemburg mal@lemburg.com
Wed, 26 Feb 2003 18:45:21 +0100


Anthony Tuininga wrote:
> SQL*Plus has autocommit but the OCI does not support it so it would have
> to be coded explicitly in DCOracle for it to be available. 

Hmm, I don't think that you can code auto-commit in a client side
interface. The point of auto-commit is that operations become
atomic and any work-around on the client side would need to issue
multiple commands in order to achieve the same effect, e.g.
run .commit() after all .execute() calls.

> As mentioned,
> DDL has an implicit commit in it and terminating the session will also
> implicitly commit any outstanding changes.

You probably mean "rollback" here, right ? A connection should
never do an implicit commit, only implicit rollbacks are allowed.

Thanks,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source  (#1, Feb 26 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
Python UK 2003, Oxford:                                     34 days left
EuroPython 2003, Charleroi, Belgium:                       118 days left