Database Software

Hi All,

I have xml data which needs to be converted to oracle table format. I have tried many ways by checking blogs and examples....but no luck

XML Payload:

------------------

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

<processResponse xmlns:ns2="http://xmlns.oracle.com/NebrasApplication/TestInboundProject/JadwalPRRest" xmlns:plnk="http://docs.oasis-open.org/wsbpel/2.0/plnktype" xmlns:ns4="http://TargetNamespace.com/JadwalPRRest_pr_response_test" xmlns:ns3="http://schemas.oracle.com/bpel/extension" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:inp1="http://TargetNamespace.com/JadwalRestService_PR_request" xmlns:tns="http://xmlns.oracle.com/NebrasApplication/TestInboundProject/BPELProcess1" xmlns="http://xmlns.oracle.com/NebrasApplication/TestInboundProject/BPELProcess1" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">

  <tns:FLOW_INSTANCE_ID>110369</tns:FLOW_INSTANCE_ID>

  <tns:GROUP_CODE>1190</tns:GROUP_CODE>

  <tns:RESULT>FAILURE</tns:RESULT>

  <tns:ERRORS>

    <tns:ERROR_MSG>Purchase Request ARZ04 does not exist.</tns:ERROR_MSG>

     <tns:ERROR_MSG>Purchase Request ARZ05 does not exist.</tns:ERROR_MSG>

  </tns:ERRORS>

</processResponse>

"

Attached screen shot is my table structure.

I need the code for the above xml to table format data. Could you please help me?

Thanks,

Pullareddy