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
-- sp body
SET @Status = 1
RETURN
GO
Here is Python code that calling stored procedure
t = text('EXEC MY_PROC :empID, :oldEmpList, :newEmpList, :Status',
bindparams=[bindparam('empID', type_=String, value='1234'),
bindparam('oldEmpList', type_=TEXT,
value='<emp><id>1</id><id>2</id>'),
bindparam('newEmpList', type_=TEXT,
value='<emp><id>e01</id><id>e02</id>'),
bindparam('Status', type_=Integer, value=0,
isoutparam=True)])
result = CMS_DBSession.execute(t)print result.out_parameters
Thanks
Aniruddha
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
