AnsweredAssumed Answered

Call for a MySQL stored procedure with a parameter doesn't run properly

Question asked by justasking on Mar 15, 2018

I'm trying to call a MySQL stored procedure through a Program Command Shape but it is giving me errors and I don't understand what's causing it.

The sproc's name is DWDimTable and I need to pass a parameter in, so I defined the parameter as a current date in a yyyy-MM-dd mask. The fill-in field for naming the sproc says to call the parameters by including a {1} so the field ends up being: DWDimTable {1} 

 

That seems to be correct, but the error when I test the process is:

 

First document failure: Errors occurred running program execution.; Caused by: Unable to execute stored procedure: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{1}('2018-03-15')' at line 1; Caused by: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{1}('2018-03-15')' at line 1

 

 

Seems like {1} is being included in the parameter's value... How do I remove it?

Outcomes