DevOps, CI/CD and Automation

Hi all.

I'm trying to parse an xml response from PL/SQL but not getting the fields back.

This is my xml:

<?xml version='1.0' encoding='UTF-8'?>

<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">

<S:Body>

<ns2:ConsultaEEHResponse xmlns:ns2="http://jeta.servicios.ws/">

<return>

<codigoError>6</codigoError>

<mensaje>El Banco se encuentra Inactivo para Recaudo.</mensaje>

<resultado>false</resultado>

</return>

</ns2:ConsultaEEHResponse>

</S:Body></S:Envelope>

This is my snippet PL/SQL code:

open p_recordset for

    with XML as

     (select XMLTYPE(vCampo1) as OBJECT_VALUE from dual)

    select *

      from XML,

           XMLTABLE(xmlnamespaces('http://schemas.xmlsoap.org/soap/envelope/' as "S",

                           default  'http://jeta.servicios.ws/'),  --  as "ns2",

                                --default 'http://schemas.servicestack.net/types'),

                   '//*:return'

                   passing OBJECT_VALUE columns

                   "codigoError" varchar2(5) PATH 'codigoError',

                   "mensaje" varchar2(200) PATH 'mensaje',

                   "Resultado" varchar2(5) PATH 'resultado') ;

end CONSULTA_EEH;

please help me. Thank you very much.