[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