The workflow was working fine until one of the fields had a single quote in the string and caused the update action to stall.
Using the Execute SQL query module I am updating data in an Oracle table. The query looks like this
UPDATE GSI_FEEDBACK_FORM_HEADERS
SET SITE_STREET = '{$ /process_data/xfaform/object/data/xdp/datasets/data/form1/Details/site_street $}',
SITE_STREET2 = '{$ /process_data/xfaform/object/data/xdp/datasets/data/form1/Details/site_street2 $}'
One of the forms had the street value
"Connah's Quay Deeside". I figured out that the single quote is causing the module to read it as the end of the XPATH, hence causing a "SQL command not ended properly" error.
Any suggestions to oversome this issue.
Aditya