Hi Conny, 

An alternative solution is to create a stored function, that does the same 
thing functionally as the stored procedure, and then call the stored function 
from a SQL set fields action. This has worked well for me many times

Guillaume


-----Original Message-----
From: Action Request System discussion list(ARSList) on behalf of Conny Martin
Sent: Thu 12/10/09 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"


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to