This content has been marked as final. Show 2 replies
Looks like one of those old (and weird) bugs related to the namespace mapping string :)
I'm still reproducing the issue on 11.2.
Try adding a whitespace in between the namespace declarations :
soap_respond := XMLTYPE(soap_respond).extract( '/soap:Envelope/soap:Body/ServiceRequest_CreateResponse/ServiceRequest_CreateResult/text()' , 'xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/", xmlns="http://ABC/"' /* ^ here */ ).getclobval();
Thanks Odie, I was breaking my head since afternoon, why its not working and I really culdnt figure it out.
Never knew that the space matters.
Thanks very much