This content has been marked as final. Show 6 replies
Try using double quotes in your expression.
Nope - No luck
ORA-00904: "1302 n 19th s't": invalid identifier
I searched the web and found a forum that discusses how to build a SQl statement with a quote in the query. Most DBs will expect you to escape it with a /. There are other techniques discussed here:
In either case it looks like you wll have to search you input string for such chars beforehand.
Just use a parameterized query, this solves the problem.
SET SITE_STREET = ?,
SITE_STREET2 = ?
Then put the xpath expressions into the table below as parameters 1 and 2.
Howard - Thank you so much for the awesome suggestion. It worked perfectly !!
You have saved me a lot of work.