DevOps, CI/CD and Automation

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!

How to extract xml to table with columns ID and NAME?

User_SMOSEJan 5 2023 — edited Jan 5 2023

<?xml version="1.0"?>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">
<soap-env:Body>
<OutputParameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.oracle.com/pcbpel/adapter/db/sp/WS_PMSfgetTerminatedPFK">
<DATA>
<Row>
<Column sqltype="VARCHAR2" name="ID">997395</Column>
<Column sqltype="VARCHAR2" name="NAME">NAME1</Column>
</Row>
<Row>
<Column sqltype="VARCHAR2" name="ID">997396</Column>
<Column sqltype="VARCHAR2" name="NAME">NAME2</Column>
</Row>
</DATA>
</OutputParameters>
</soap-env:Body>
</soap-env:Envelope>

This post has been answered by Solomon Yakobson on Jan 5 2023

Jump to Answer

Added on Jan 5 2023

#database, #pl-sql-xml-programming, #xml

1 comment

529 views