Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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