Calling Stored Procedure in Process

BLOMASKY

I have no problems using a SQL Server Stored Procedure (SP) in a query and displaying the results in the query.

However, I would like to call a SP, and then process each returned record.

This works fine in a query:
EXEC_SP 'ReadUnitLengthTotals' WITH '@Item'=LoggedInRegularUser.selectedItem.ID RETURN ItemTemplatesForSP

However, I am not getting any result set if called from a process. The Rules guide says:
"The resulting object instances are either placed in the Context if the EXEC_SP action is used in rules or returned by a query if the action is used in a rule form of the query"

If it is in context, then how can I access each record?

Thanks
Bruce

customaware

I have never done it Bruce but I would expect that you call a Sub Process immediately after the EXEC_SP line and that would execute with each returned instance in context.