Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Double Quotes in tOracleInput Query Causing Invalid Character Constant

Hi,
I am using an INSTR in my SQL query to find the position of the next double quote in the data I am querying. I have tried using backslashes however I still get the Invalid Character Constant. Is there any method in dealing with the double quotes. For the purposes I won't get into I need this query to be extracted using SQL not later with Java in a tMap for instance.
Many thanks,
Brian

Labels (2)
1 Reply
Anonymous
Not applicable
Author

have you tried using char function to replace the quotes?