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"

Reply via email to