Database Software

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!

Parsing SOAP respone with Oracle XMLTABLE | Help required

3634505Mar 24 2018 — edited Mar 25 2018

I've a SOAP response,

<SOAP-ENV:Envelope

xmlns:SOAP-ENV=""http://schemas.xmlsoap.org/soap/envelope/""

xmlns:SOAP-ENC=""http://schemas.xmlsoap.org/soap/encoding/""

xmlns:functioninvoker=""xalan://com.bil.engine.technical.map.FunctionInvoker"">

<SOAP-ENV:Header></SOAP-ENV:Header>

<SOAP-ENV:Body>

<m:InitatePort

xmlns:m=""http://www.testmap.eu/WSG/uc/"">

<m:RepStatus>

<m:Flag>Y</m:Flag>

<m:Text>OK</m:Text>

</m:RepStatus>

<m:NMB>00489576416</m:NMB>

<m:RequestId>11072016485900163816</m:RequestId>

<m:CSPId>1107</m:CSPId>

<m:GMCId>0001</m:GMCId>

<m:LMCId>0002</m:LMCId>

<m:LCSPId>0002</m:LCSPId>

<m:RejParty>0002</m:RejParty>

<m:Rejcd>058</m:Rejcd>

<m:Result>AEQQM</m:Result>

</m:InitatePort>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

This SOAP response is save as clob in a table. I will convert that clob to xmltype. What I want to know is, how I can defined namespaces, XPATH and other variable to fetch value of the variable defined between path. I will then save these to another table. I'm trying to use XMLTABLE but unable to properly defined its parameters, with this response. ~DK

This post has been answered by cormaco on Mar 25 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2018

Added on Mar 24 2018

#performance-availability, #xml-db

2 comments

2,201 views