PL/SQL (MOSC)

MOSC Banner

Problem with extracting data from XMLTYPE

edited Sep 9, 2015 10:05AM in PL/SQL (MOSC) 6 commentsAnswered

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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center