Returning results from a SQL stored procedure, SQL Stored Procedure

I am trying to return results from a Microsoft SQL Stored Procedure. I am calling the following SQL statement:

EXEC pr__sms_mayfly_pull {M}

The stored procedure returns a field called "sms_message". The procedure runs without anything in the Succ Return field but when I put {sms_message} in the Succ Return, and test it, I get the error:

Test Successfully. The return is followed: ERROR FIELD

When I run this directly from SQL, I get the results correctly.

Please help. Thanks, Neil

Please check out http://www.visualtron.com/forums/index.php...tored+procedure

I managed to resolve this issue. The issue was with the type of the text returned. It was returning a TEXT type rather than a CHAR type so I just used the CONVERT(CHAR(8000), field) to change the type and it works fine.

Yes, SQL action can only process char or varchar.

Here's an example of a stored procedure created using SQL Server Express 2005 Management Studio Express. Refer to the attached screen capture on the setup for the keyword "CHECK". There's a lot you can do with a stored procedure using Transact-SQL functions, here's a reference link.

Note: The DSN section is unfilled since we are querying VisualGSM database. If you need to query an external ODBC Data Source, please create a SYSTEM DSN.

Attached Image

Please can you show how to pass in an OUTPUT PARAMETER and have this in Succ Return?

You can toggle "SELECT" and put the fieldname in curly brackets within the Succ Return field.