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"

Reply via email to