'test setting input sizes with positional args'

def testSetInputSizesByPosition(self):

    var = self.cursor.var(cx_Oracle.STRING, 100)
    self.cursor.setinputsizes(None, 5, None, 10, None, cx_Oracle.NUMBER)
    self.cursor.execute('\n                                                                begin\n                                                                        :1    :=    :2    ||    to_char(:3)    ||    :4    ||    to_char(:5)    ||    to_char(:6);\n                                                                end;', [var, 'test_', 5, '_second_', 3, 7])
    self.failUnlessEqual(var.getvalue(), 'test_5_second_37')
