Conny, Yes it is possible.. how are you calling/executing the stored procedure when you are using it in the set-field-sql?
Begin <procedure name>; works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if you need the semi colon in the end) I'm not sure if that would work with MS-SQL as well but you could try that.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Conny Martin Sent: Thursday, December 10, 2009 3:08 AM To: [email protected] Subject: Get result from stored procedure All, Not sure if this is possible, but is there a way to get the results from a stored procedure via set-field-sql into ars. This works in Query-Analyzer declare @p_result int exec SP_TEST 'MDP000000072713', @p_result output select @p_result But in a set-fields-sql $1$ is always null. ARS 7.1p6 MSSQL 2005 W2K3 Enterprise Server Any help is really appreciated. Thanks Conny _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

