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

def testBindUnicodeArrayByVar(self):

    returnValue = self.cursor.var(cx_Oracle.NUMBER)
    array = self.cursor.arrayvar(cx_Oracle.NCHAR, 10, 20)
    array.setvalue(0, [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=7, array=array)
    self.failUnlessEqual(returnValue.getvalue(), 118)
