Thanks for reply. I checked the link it says if stored procedure end with
select statement, it will solve problem.
In my stored procedure, I am passing XML data, getting all values from that
xml put into temp table.
CREATE PROCEDURE MY_PROC
@empID char(10),
@oldEmpList XML,
On Apr 5, 2014, at 3:23 AM, Aniruddha anierud...@gmail.com wrote:
Thanks for reply. I checked the link it says if stored procedure end with
select statement, it will solve problem.
In my stored procedure, I am passing XML data, getting all values from that
xml put into temp table.
Hi,
I am trying to execute stored procedure from python / pyramid code. I am
passing 3 input 1 output parameter. But I am not able to receive output
parameter back.
Here is Stored Procedure
CREATE PROCEDURE MY_PROC
@empID char(10),
@oldEmpList XML,
@newEmpList XML,
@Status INT OUTPUT
as far as I know, pyodbc does not support OUT parameters. The info they have
on stored procs is here:
http://code.google.com/p/pyodbc/wiki/StoredProcedures
if you want to work with the Pyodbc cursor directly (or any other cursor, like
that of pymssql perhaps):
conn = my_session.connection()