Problem with extracting data from XMLTYPE
Hallo,
I'm quering data from a SAP webservice using the UTL_HTTP package.
Finally I get a XMLTYPE object
mydoc xmltype;
and would like to write a value into
my_EAdr_2 varchar2(5000);
The XMLTYPE looks internally like this :
soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">
<soap-env:Header>
</soap-env:Header>
<soap-env:Body>
<n0:ZzMitglFormWbs2Response xmlns:n0="urn:sap-com:document:sap:soap:functions:mc-style">
<EAdr_1>Herrn</EAdr_1>
<EAdr_10></EAdr_10>
<EAdr_2>Testpensionierungxxx Bischoff</EAdr_2>
<EAdr_3>Teststrasse 110</EAdr_3>
<EAdr_4>12345 Stadt</EAdr_4>
<EAdr_5></EAdr_5>
<EAdr_6></EAdr_6>
<EAdr_7></EAdr_7>
<EAdr_8></EAdr_8>
<EAdr_9></EAdr_9>
<EGbdat>1938-01-01</EGbdat>
<EName>Bischoff</EName>
<EOk>FormularZZKMR_67100erstellt!</EOk>