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!

String to XML parsing in Oracle SOA BEPL(getting failed because of special character)

2829743Nov 2 2015 — edited Feb 26 2020

Hi Experts,

I am trying to use oraext:parseEscapedXML() function to parse xml string to xml schema. This function is working fine for me but whenever I am getting "H&" or any special character in input tag, it's failing to parse.

Can someone please suggest me how to handle this problem. ? I am using BPEL 2.0 and SOA 12c Suit.

This is my BPEL Assign

<assign name="Assign2">

            <extensionAssignOperation>

                <bpelx:append ignoreMissingFromData="yes" keepSrcElementName="yes">

                    <bpelx:from>oraext:parseEscapedXML($inputVariable.payload/client:input)</bpelx:from>

                    <bpelx:to>$anyType</bpelx:to>

                </bpelx:append>

            </extensionAssignOperation>

        </assign>

This is my input string

<?xml version="1.0" encoding="windows-1252"?>

<orderStatus xmlns="http://www.example.org">

   <line_list>

      <line_id>16-10</line_id>

      <line_status>open</line_status>

      <line_number>9614801</line_number>

   </line_list>

   <line_list>

      <line_id>17-11</line_id>

      <line_status>open</line_status>

      <line_number>9614802</line_number>

   </line_list>

<DeliveryID>8885673-002</DeliveryID>

   <lineHoldExist>false</lineHoldExist>

   <TransStatus>OPEN</TransStatus>

   <parseOrderClobResult_RespCode>00</parseOrderClobResult_RespCode>

   <parseOrderClobResult_RespMsg>Parsing Order Response is success</parseOrderClobResult_RespMsg>

   <ForwarderID>00654-002</ForwarderID>

   <ForwarderName>H&amp;FRIENDS GTL(USA) INC</ForwarderName>

   <ForwarderAddress1>H&amp;FRIENDS C/O PEREGRINE TRUCKING</ForwarderAddress1>

   <ForwarderAddress2>15161 SOUTH FIGUEROA STREET</ForwarderAddress2>

   <ForwarderAddress3></ForwarderAddress3>

   <ForwarderCityStateZip>GARDENA, CA  90248  US</ForwarderCityStateZip>

   <ForwarderCity>GARDENA</ForwarderCity>

   <ForwarderState>CA</ForwarderState>

   <ForwarderZip>90248</ForwarderZip>

   <ForwarderCountryName>UNITED STATES</ForwarderCountryName>

   <ForwarderCountryCode>US</ForwarderCountryCode>

</orderStatus>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2015
Added on Nov 2 2015
3 comments
2,564 views