Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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+"'"