'test binding in a unicode array (with setinputsizes)'

def testBindUnicodeArrayBySizes(self):

    returnValue = self.cursor.var(cx_Oracle.NUMBER)
    self.cursor.setinputsizes(array=[cx_Oracle.NCHAR, 10])
    array = [r[1] for r in self.rawData]
    self.cursor.execute('\n                                                                begin\n                                                                        :retval    :=    pkg_TestUnicodeArrays.TestInArrays(:integerValue,\n                                                                                        :array);\n                                                                end;', retval=returnValue, integerValue=6, array=array)
    self.failUnlessEqual(returnValue.getvalue(), 117)
