Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to parse string-xml through parseEscapedXml

708452Aug 11 2009 — edited Feb 26 2020
Hi all,
What I am doing is, I am getting some data through polling and populating a schema variable. Because of having extra namespace in the resultant xml, I again used processXSLT and assigned the resultant xml to a string variable (after converting it to string).
Now I want to pass this string to my web service. When I tried the
ora:parseEscapedXML(ora:getContentAsString(bpws:getVariableData('niku_xog_project_write_xml_as_string')))

It is giving the xpath error ORABPEL-09500. However when I remove the parseEscapedXML function, I am able to see the correct data on server. But it doesn't work because web-service expecting the xml instead of string.

Below is the xml in string format. I picked it from server log.

*<NikuDataBus><NikuDataBus>*
*<Header version="12.0.1.5063" externalSource="NIKU" action="write" objectType="project"/>*
*<Projects>*
*<Project name="Web tech support" projectID="0066000000AAJFLAA5" description="The tech support calls are currently being handled in N America internally. Charter is trying to cut costs and the contact centers are high on the list. They are somewhat sceptical about moving the calls offshore, but are open to discussions about CR as a solution for web tech support. This account will most likely issue a RFP in late April or early May." >*
*<CustomInformation>*
*<ColumnValue name="client_name">Comcast Cable Holdings Llc</ColumnValue>*
*<ColumnValue name="fa_sales_owner">John Harris</ColumnValue>*
*<ColumnValue name="prj_category">Complex Deals</ColumnValue>*
*<ColumnValue name="fa_offering_practice">BPO &amp; Call Center Services</ColumnValue>*
*<ColumnValue name="fa_offering_category">BPO &amp; Call Center Services</ColumnValue>*
*<ColumnValue name="fa_offering_type">Express Services - Complex Arrangement</ColumnValue>*
*<ColumnValue name="fa_isales_stage">Qualifying Deal</ColumnValue>*
*<ColumnValue name="probable_win">5</ColumnValue>*
*<ColumnValue name="fa_delivery_location"/>*
*<ColumnValue name="fa_contract_type">T&amp;M</ColumnValue>*
*<ColumnValue name="prj_type">2</ColumnValue>*
*<ColumnValue name="prj_classification">1</ColumnValue>*
*</CustomInformation>*
*</Project>*
*</Projects>*
*</NikuDataBus>*
*</NikuDataBus>*

What should I do?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2011
Added on Aug 11 2009
20 comments
10,933 views