Dataservice stored procedure call

Posted by Admin on 05-Jun-2008 09:43

Hi,

In the help I found:

With parameters and a returned result parameter:
{@result= call procedure_name[(@parameter_name_1, @parameter_name_2, ...)]]>



When I try to execute:

{ @

also

{ @result= CALL dbo.P_SetUpdate[('MY', 'A123')]}
fails

This stored procedure returns 0 or
-1 to determine if update was successful

The @result is set to OUT. The
dataservice returns and error of invalid syntax near
{

Any Ideas?


Thanks

result= CALL dbo.P_SetUpdate('MY', 'A123')}]]>


		   Technology Partner - Forum


	
		All Replies
		
		
		  Posted by Admin on 12-Jun-2008 11:10
		  
Your markup seems to be slightly broken, so I cannot tell if you already tried this. Try the following syntax:
The [] in the manual indicates that that bit of the syntax is optional and they should not be included in the actual SQL for the call.

		
		
		
				 This thread is closed