[PyDB2-discuss] RE：[PyDB2-discuss] db2 callproc error

[gongjingqun <gon...@ba...>]

Hey,
:This email responses the topic "PyDB2-discuss] db2 callproc error" because of
Email Archive: pydb2-discuss  showing to me read-only.

I just use following test case coming from ./PyDB21.1.1/test/test_basic.py:

import DB2
db = DB2.connect(dsn=db,uid=usr,pwd=ps)
cur = db.cursor()

cur.execute(
   """CREATE PROCEDURE CP_TEST_1
   (IN P1 CHAR(5), OUT P2 VARCHAR(5), INOUT P3 INTEGER)
   LANGUAGE SQL
   BEGIN
    SET P2 = 'YYY';
    SET P3 = 3;
   END""")
db.commit()
params = ( 'XXXXX', None, 1 )
r = self.cs.callproc('CP_TEST_1', params)

To make sure of the procedure,i call it under the administrator mode:
>db2
>connect to db usr usr using ps
>call CP_TEST_1('XXXXX',None,1)
and its ok.

Then ,i installed the old version of v1.1.0-3, it also doesn't work.

Thanks!