[Zope-DB] DCOracle2 and multiple SQl statements

[Matthew T. Kromer]

Smith, Neil wrote:

>I've just noticed with horror that when a sql method was called that had
>multiple sql statements (separated by <dtml-var sql_delimiter>) and one of
>them failed, the preceding statements have been committed.  I was under the
>impression that the whole thing should be rolled back.  Is that not how it
>is supposed to work?
>
>I'm using Zope 2.4.3 binary release on Windows NT 4 and DCOracle2-pre1.
>

Thats what is supposed to happen, yes.  Unless you call something that 
explicitly does a commit() there shouldn't be any problem with issuing 
multiple statements in the same transaction.