[python-sybase] RE: Sybase Module 0.36 Output Parameter Handling

Bradley Feldman bradley at relevantevidence.com
Thu, 17 Mar 2005 12:59:44 -0800


On a hunch, I reverted back to the original FreeTDS (0.62.4) I was using
that works with the Sybase 0.63 module.  I then tried the same test within
tsql:

1>DECLARE @ReturnValue int
2>SELECT @ReturnValue = 3
3>EXEC sp_TestSproc 12345, @ReturnValue OUTPUT
4>SELECT @ReturnValue
5>go
(return status = 0)

55
---------------------------

I got the correct result, @ReturnValue of 55.   So there's something wrong
with the handling of output parameters within the Sybase 0.36 module,
because tsql through FreeTDS is seeing everything correctly.

Anyone have any other ideas on where/how to retrieve the value of output
parameters using callproc in the Sybase 0.36 module?

Thanks in advance,

*Bradley