0

How can I fetch the data out of the query? I need the tags "Result", "ApprovalCode" and "id" from the body:

<ns28:response xmlns:ns2="xx" xmlns:ns40="yy" Result="Approved"ApprovalCode="529827"><ns28:Specific><ns14:CardVsdc Id="3"/></ns28:Specific>
    select Id
      into v_RiskLevel
      from xmltable('/response' passing g_xmlResult columns 
                    Id varchar2(50) path '@ApprovalCode');
2
  • 1
    @SaintLike Not quite a duplicate of that link as it's Oracle PL/SQL. But it is a duplicate of Extracting values from xml in Oracle PL/SQL Commented Jul 24, 2019 at 10:01
  • Also it's incomplete XML and not valid in its current state. Commented Jul 24, 2019 at 10:05

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.