Extracting repeating group from SOAP envelope in PL/SQL
Hi all.
I have the following SOAP envelope in an XMLTYPE variable in PL/SQL.
<?xml version = "1.0" encoding = "UTF-8"?>
<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://elmarwsoicdvmws/types/">
<env:Body>
<ns0:getDVMValuesResponseElement>
<ns0:result>
<ns0:dvmValues>10</ns0:dvmValues>
<ns0:dvmValues>11</ns0:dvmValues>
<ns0:dvmValues>12</ns0:dvmValues>
<ns0:errorText>Ok</ns0:errorText>
<ns0:errorCode>0</ns0:errorCode>
</ns0:result>
</ns0:getDVMValuesResponseElement>
</env:Body>
</env:Envelope>'
I can extract the errorCode and ErrorText variables without too much effort (though I'm sure there are easier ways), but now I have to extract the repeating group of dvmValues into an array type variable.
Any ideas/code snippets would be greatly appreciated, as I've been reading tons of docs and half the time they are too complex or too simplistic (given my ns0: variables), and it seems a lot of the functions I've been using have been depricated.
Kind regards
Elmar