For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi, Does Oracle certifies the environments based on VMWare virtualization for Solaris 11? Does it support for Solaris 11 on VMware platform?
Appreciate your help. Thanks.
with t (vCampo1) as (select '<?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>' from dual)select a.*from t,XMLTABLE( xmlnamespaces( 'http://schemas.xmlsoap.org/soap/envelope/' as "S", 'http://jeta.servicios.ws/' as "ns2" ), '/S:Envelope/S:Body/ns2:ConsultaEEHResponse/return' passing xmltype(vCampo1) columns codigoError varchar2(5) PATH 'codigoError', mensaje varchar2(200) PATH 'mensaje', Resultado varchar2(5) PATH 'resultado')a ;
with t (vCampo1) as
(
select
'<?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>'
from dual
)
select a.*
from t,
XMLTABLE(
xmlnamespaces(
'http://schemas.xmlsoap.org/soap/envelope/' as "S",
'http://jeta.servicios.ws/' as "ns2"
),
'/S:Envelope/S:Body/ns2:ConsultaEEHResponse/return'
passing xmltype(vCampo1)
columns
codigoError varchar2(5) PATH 'codigoError',
mensaje varchar2(200) PATH 'mensaje',
Resultado varchar2(5) PATH 'resultado'
)a
;
Yes. Thank you very much, I try similar way, but I missed one ")" so a got compilation error. Some time you got the answer in front of you but got blind. Appreciate your help.