XML function not getting compiled in Pro C

Resehord

New Member
I have written following statement in ProC\[code\]EXEC SQLselect extract(x.xml_data,'//ADDRESS/SERVERS/@REFSYSTEM').getStringVal(),extract(x.xml_data,'//ADDRESS/SERVERS/text()').getNumberVal()INTO :h_refsystem,:h_reftextfrom xml_str_table x where key_no = 1234 and x.xml_data.existsNode('//ADDRESS/SERVERS[@REFSYSTEM="ORACLE"]') = 1 ;\[/code\]and when compiled it give error " \[code\]extract(x.xml_data,'//ADDRESS/SERVERS/@REFSYSTEM').getStringVal() . should be replaced with date, time etc"\[/code\]Above query is returning output when I run on Oracle, but same code is not getting compiled in Pro C. Can you please advise what should be done to resolve this issue?Thanks in advance,
 
Back
Top