[Tutor] Output parameters from a stored procedure

Hansen, Mike Mike.Hansen at atmel.com
Thu Oct 9 21:11:34 CEST 2008


Does anyone know how to get the output parameters from a stored procedure?

I'm using pymssql on a linux box to call a stored procedure on a mssql
database. I'm not sure of the correct syntax to get the output
parameters.

import pymssql

con = pymssql.connect(host='xxxxx',user='xxxx',password='xxxxx',database='xxxxx')

cur = con.cursor()

query = "EXECUTE blah blah blah"

cur.execute(query)
con.commit()
con.close()

Mike


More information about the Tutor mailing list