[DB-SIG] stored procedures

Mike Skowronski mskow@crosslink.net
Tue, 2 Feb 1999 22:02:33 -0500 (EST)


Hi,

I'm using the odbc module w/ python 1.5.1 to call stored procedures and
they work fine except when the procedure (or the return value on
a function) has an output value.  For example if I have something like:

	ret = 0
	params = [ret, 1, 2]
	aCursor.execute('{? = call addthem(?,?)}', params)
	
the value of ret would always be 0 even though if i call the same function
from C or pl/sql it behaves correctly -- i.e. adding the 2 input
parameters for above e.g.  any suggestions?

Mike