<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I found this post:<br>
<br>
<a class="moz-txt-link-freetext" href="http://bytes.com/groups/python/38259-sql-server-stored-prcedures-output-parameters">http://bytes.com/groups/python/38259-sql-server-stored-prcedures-output-parameters</a><br>
<br>
which was helpful in getting me started. However, that method does not
yield the output parameters if a recordset is output in the SP. So, if
my SP is:<br>
<blockquote><tt>CREATE PROCEDURE sp_test_only_output<br>
@param INTEGER OUTPUT<br>
AS<br>
BEGIN<br>
select @param = 10<br>
END</tt><br>
</blockquote>
Then:<br>
<blockquote><tt>assert [10] ==
self.cur.callproc('sp_test_only_output',(999,))<br>
</tt></blockquote>
But, if my SP is:<br>
<blockquote><tt>CREATE PROCEDURE sp_test_output_and_select<br>
@param INTEGER OUTPUT<br>
AS<br>
BEGIN<br>
select 'one', 'two'<br>
select @param = 10<br>
END<br>
</tt></blockquote>
then:<br>
<blockquote><tt>self.cur.callproc('sp_test_output_and_select',(999,))
== [999]<br>
</tt></blockquote>
A full test that can be run with Nose:
<a class="moz-txt-link-freetext" href="http://paste.pocoo.org/show/118219/">http://paste.pocoo.org/show/118219/</a><br>
<br>
Can you please help me figure out what is going on. I realize output
parameters are not the best solution, but I am working with systems
that I can't change the SPs on and would like to use Python rather than
be forced into using a different language.<br>
<br>
Thank you!<br>
<br>
<pre class="moz-signature" cols="72">--
--------------------------------------
Randy Syring
RCS Computers & Web Solutions
502-644-4776
<a class="moz-txt-link-freetext" href="http://www.rcs-comp.com">http://www.rcs-comp.com</a>
"Whether, then, you eat or drink or
whatever you do, do all to the glory
of God." 1 Cor 10:31
</pre>
</body>
</html>