'test iterators (with intermediate execute)'

def testIteratorsInterrupted(self):

    self.cursor.execute(u'truncate    table    TestExecuteMany')
    self.cursor.execute(u'\n                                                                select    IntCol\n                                                                from    TestNumbers\n                                                                where    IntCol    between    1    and    3\n                                                                order    by    IntCol')
    testIter = iter(self.cursor)
    (value,) = testIter.next()
    self.cursor.execute(u'insert    into    TestExecuteMany    (IntCol)    values    (1)')
    self.failUnlessRaises(cx_Oracle.InterfaceError, testIter.next)
