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!

how to Convert XML String to structured XMLObject Type

652977Oct 22 2008 — edited Oct 1 2012
Hi All,

I am getting xml as a String and i need to convert it in to XML Object Type.

For example i am getting following xml as a string.

inputXML = " <email> <ovdTriggeredDate>16thFeb</ovdTriggeredDate> <request> <requestId>1111</requestId> <service>OVDOngoing</service> <action>Retry</action> <client>Batch</client> <delivery>email</delivery> <locale> <countryCode>US</countryCode> <languageCode>English</languageCode> </locale> </request> </email>"

now i need to convert above string in to XML object and map it to schema

<xsd:element name="email">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ovdTriggeredDate" type="xsd:string" minOccurs="1"/>
<xsd:element name="request" type="RequestType"/>
</xsd:element>

<xsd:complexType name="RequestType">
<xsd:sequence>
<xsd:element name="requestId" type="xsd:long" minOccurs="1"/>
<xsd:element name="service" type="xsd:string" minOccurs="1"/>
<xsd:element name="action" type="xsd:string" minOccurs="1"/>
<xsd:element name="client" type="xsd:string" minOccurs="1"/>
<xsd:element name="delivery" type="xsd:string" minOccurs="0"/>
<xsd:element name="locale" type="xsd:string" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>

Can anybody help me ? how can i do this with Assign activity.

thanks in advance.

Thanks,
Nimisha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2012
Added on Oct 22 2008
7 comments
3,025 views