Joe,
I'm calling it the same way as in Query Analyzer.
declare @p_result int
exec SP_TEST 'MDP000000072713', @p_result output
select @p_result
No Errormessage is returned but $1$ doesn't get the value from p_result
With oracle there is no problem. One can just do
select sp_test('MDP000000072713') from dual
but I don't know the correct syntax for MS-SQL.
Kind Regards Conny
-----Ursprüngliche Nachricht-----
Von: Action Request System discussion list(ARSList)
[mailto:[email protected]] Im Auftrag von Joe D'Souza
Gesendet: Donnerstag, 10. Dezember 2009 10:32
An: [email protected]
Betreff: Re: Get result from stored procedure
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"