Execute Stored Procedure from an Action When Completed

Could someone please share the syntax for the procedure name and the parameters for an Execute Stored Procedure activity which uses two parameters? The error I get is:

Details:Failed to execute deployed method 'WhenActionCompleted', using entity 'PatRegFlag'. Exception 'Exception 'Syntax error or access violation' occurred when attempting to 'Execute stored procedure'.' occurred when attempting to 'Execute workflow 'e051843b-3eb9-4e46-bb1d-91cb6928ce3a''. Exception 'Syntax error or access violation' occurred when attempting to 'Execute stored procedure'.

Find more posts tagged with

BPM

Comments

Jerome_Pearce

I'm not sure what you need to pass in. It expects text, which means paramaters like text and dates will need formatting.

We use SelectSql() anyway as it makes everything easier to read and edit, and the use of parameters negates the need to format text and dates. See our Hints & Tips

Rick Kushner

I will be happy to use SelectSQL() if it can be used in an action When Completed, but I don't see how/where.

I just need to pass two text parameters to my stored procedure and they are both text. I don't mind doing the formatting, but I can't find any explanation or example of the syntax. My parameters are both folder IDs, one from the flag and the other from the process context.

Thanx!!!

Jerome_Pearce

Use it in a code activity. The syntax for SelectSql() is in the user manual and help, and there are several good examples here