Execute query - parameters

Hi Team,

I’m using “Execute Query” activity under Database and calling the stored procedure.
For this I’m using parameter under edit sql.

I can create a variable but once I will save reopen the parameters section variables not getting saved and unable to use in the query.

I’m not sure is it really a bug or i’m doing something wrong.
Appreciate your help in advance.!

Attached is the Screenshot.

issue resolved thanks.

By the way we have to use ? in the sql query as per the variable order defined in the parameters.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.