'test executing a statement with a dictionary argument'

def testExecuteDictionaryArg(self):

    simpleVar = self.cursor.var(cx_Oracle.NUMBER)
    dictArg = {u'value': simpleVar}
    result = self.cursor.execute(u'begin    :value    :=    10;    end;', dictArg)
    self.failUnlessEqual(result, None)
    self.failUnlessEqual(simpleVar.getvalue(), 10)
