Five Stars

Invalid Character Constant when Executing stored procedure

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

Tags (1)
1 REPLY
Seven Stars

Re: Invalid Character Constant when Executing stored procedure

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