This discussion is archived
1 Reply Latest reply: Jul 28, 2012 2:05 PM by user10177353 RSS

XPath in JDK1.4 - Please help

user10177353 Newbie
Currently Being Moderated
Hi There,
Can some one help me with the code for XPath in JDK1.4.2 I have a scenario where I would get the XML Message from Tibco EMS Message as a String. I should parse the XML into a PL/SQL Record type. i.e., Each of the Name/Value tags below would become a Column and Value for PL/SQL Record type.
If you have a better approach please advice.

Below is the XML I would get from EMS Message.

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns="http://emsapp/InvoiceOrderStatusNotification">
<SOAP-ENV:Body>
<invoiceOrderStatusNotification>
<invoiceOrderStatusNotificationMessage>
<sourceSystem>
<sourceSystemType>Invoice Order Manager</sourceSystemType>
<sourceSystemId>INVOICE-APP</sourceSystemId>
</sourceSystem>
<alternativeIdentifiers>
<alternativeIdentifier>
<name>invoiceNumber</name>
<value>0312345678</value>
</alternativeIdentifier>
<alternativeIdentifier>
<name>orderNumber</name>
<value>12345678</value>
</alternativeIdentifier>
</alternativeIdentifiers>
<characteristics>
<characteristic>
<name>invoiceDateTime</name>
<value>20120613123625</value>
</characteristic>
<characteristic>
<name>invoiceMethod</name>
<value>MAN</value>
</characteristic>
</characteristics>
</invoiceOrderStatusNotificationMessage>
</invoiceOrderStatusNotification>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Please help, thanks in advance.
PS: I have to achieve it in JDK1.4.2 as my produciton is currently running on JDK1.4.2 :(

Edited by: user10177353 on Jul 29, 2012 2:35 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points