Envelope SOAP de resposta :
<env:Envelope
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ns0="http://oracle.ovs.api/types/"
xmlns:ns1="http://www.oracle.com/webservices/internal/literal">
<env:Body>
<ns0:queryLocalDisksResponseElement>
<ns0:result
xsi:type="ns1:arrayList">
<ns1:item
xsi:type="ns0:VirtualDisk">
<ns0:status
xsi:nil="1"/>
<ns0:diskName>System</ns0:diskName>
<ns0:priorityClass>0</ns0:priorityClass>
<ns0:frontEnd>xvda</ns0:frontEnd>
<ns0:virtualDiskId>269</ns0:virtualDiskId>
<ns0:hardDiskDriver>
<ns0:hardDriveType>auto</ns0:hardDriveType>
</ns0:hardDiskDriver>
<ns0:mode
xsi:nil="1"/>
<ns0:qosEnable>false</ns0:qosEnable>
<ns0:sharable>false</ns0:sharable>
<ns0:attachStatus>Attached</ns0:attachStatus>
<ns0:comments
xsi:nil="1"/>
<ns0:diskSize>6205</ns0:diskSize>
<ns0:deviceName
xsi:nil="1"/>
<ns0:deviceSize
xsi:nil="1"/>
<ns0:deviceUuid
xsi:nil="1"/>
</ns1:item>
</ns0:result>
</ns0:queryLocalDisksResponseElement>
</env:Body>
</env:Envelope>
e como estou configurando a SQL do report:
select
extractValue(value(t),'/*/diskName','xmlns="http://oracle.ovs.api/types/"') "diskName"
from wwv_flow_collections c,
table(xmlsequence(extract(xmltype.createxml(c.clob001),'//queryLocalDisksResponseElement/result/item','xmlns="http://oracle.ovs.api/types/"'))) t
where c.collection_name = 'RESP_LOCALDISK'