PL/SQL (MOSC)

MOSC Banner

Need Help - How to read/get the data from XMLTABLE

in PL/SQL (MOSC) 5 commentsAnswered

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>

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