You are viewing limited content. For full access, please sign in.

Question

Calling a stored proc with an output parm from workflow?

Workflow Version 10

Updated April 10, 2020

asked on April 10, 2018

Hello,

Is it possible to call a stored proc with an output parm from workflow? For example, if I want to make a call like below:

exec [dbo].[sp_MyProc] @Parm1, @MyOutputParm OUTPUT

I've tried this but don't see how I would access @MyOutputParm. It seems the Parameters section of a custom query activity is only meant for input parameters (unless I am missing something...)

Thanks,
Julie

0 0

Replies

replied on April 11, 2018

Hi Julie,

I have used the Custom Query to call stored procedures.

The output of the query will be available as new tokens within the workflow, you don't have to create them.

Hope that helps!

2 0

replied on April 11, 2018

Hi Andrew,

Thanks for the response. Although it looks as though you are not using an output parm in that case. I've called stored procs from workflows before with no problem; but in this case I am wanting to use an output parm so I can call it from both workflows and other stored procs easily.

Thanks,

Julie

0 0

replied on April 10, 2020

Any update on this please?

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked April 10, 2018
Updated April 10, 2020
476 views