We get a XML response from a WEB-SERVICE.
I convert it to VARCHAR2.
Now, I want to get the actual reponse which is in the Response tag.
I tried this:
DECLARE
v_1 VARCHAR2(30000) := '<soap:Body><ns:ProcessArgusFeedsResponse xmlns:ns="urn:PegaRULES:SOAP:ArgusToPegaFeeds:Services">' ||
'<Response>Good</Response></ns:ProcessArgusFeedsResponse></soap:Body>';
v_response VARCHAR2(100);
BEGIN
DBMS_OUTPUT.PUT_LINE(V_1);
v_response := REGEXP_SUBSTR(v_1, '/<Response>(.+?)<\/Response>/');
dbms_output.put_line(v_response);
END;
This does not work.
Any help would be greatly appreicated.