Need Help - How to read/get the data from XMLTABLE
Hi
Good morning. I have a table like the following
CREATE TABLE apps.lfcx_http_xml
(ID NUMBER,
URL VARCHAR2(100),
DATA CLOB
);
The data comes from invoking the REST Web API and is getting populated like the following
<ArrayOfMultivault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Galaxy.SOFI.Entities">
<Multivault>
<ClientNo>1</ClientNo>
<Name>Glory Test Bank</Name>
</Multivault>
<Multivault>
<ClientNo>3</ClientNo>
<Name>10New Data45</Name>
</Multivault>
<Multivault>
<ClientNo>6</ClientNo>
<Name>LEUKEMIA AND LYMPHOMA SOCIETY COMM</Name>
</Multivault>
<Multivault>
<ClientNo>8</ClientNo>
<Name>1ST US COMMUNITY CU </Name>
</Multivault>
<Multivault>
<ClientNo>10</ClientNo>
<Name>SACRAMENTO CU </Name>
</Multivault>