I am trying to run sc_itg_run_ora_sql and the select statement includes an append
QUERY_STRING="select '"'||t1.parameter4||'"' from kcrt_req_header_details T1"
ie ' " ' | ' " '
The double quote " is causing PPM to error. How do you escape this out? I've tried everything I could think of. I need to end up with quotes around the results
"field1" "field2" instead of just field1 field2
Go to Solution.
Try using chr(34) in place of '"'.
Also check your SQLPLUS_ESCAPE_CHARACTER on the PPM server.conf and teh use the caracter to escape the double quote.
Hope this helps.