How to extract from xmltype
930817Apr 17 2012 — edited Apr 18 2012Hi,
Below is the response im getting from a web service.
This is being stored in a variable of type XMLTYPE
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Header/>
<env:Body>
<TICKETCreateRespMsg xmlns="http://www.testurl.com/webservices/">
<body xmlns="">
<CreateTicket>
<TICKET_NO>A-32758628</TICKET_NO>
<SUMMARY></SUMMARY>
<ERROR_MSG></ERROR_MSG>
</CreateTicket>
</body>
</TICKETCreateRespMsg>
</env:Body>
</env:Envelope>
Since I am new to this, I am not able to figure out how to extract the text values of nodes TICKET_NO,SUMMARY and ERROR_MSG
Please help.