Invalid Character Constant when Executing stored procedure

Anonymous — Thu, 05 Oct 2017 17:54:37 GMT

Hello,

Using MsSQLInput component in Talend Open Studio to execute a stored procedure with context variables as parameters.

Command I gave is below: It however complains of Invalid Character constant.

What is wrong with this command here?

Any idea of what is wrong here?

"EXEC sp_Cleanup_Table" '"+context.Version+"','"+context.ReportStartMonth+"','"+context.ReportEndMonth+"','"+context.ReportType+"'

TIA

Re: Invalid Character Constant when Executing stored procedure

Anonymous — Thu, 05 Oct 2017 18:43:41 GMT

Try by switching the qoutes
"EXEC sp_Cleanup_Table '" +context.Version+"','"+context.ReportStartMonth+"','"+context.ReportEndMonth+"','"+context.ReportType+"'"

topic Invalid Character Constant when Executing stored procedure in Talend Studio

Invalid Character Constant when Executing stored procedure

Re: Invalid Character Constant when Executing stored procedure