Database Software

Hi All

Kindly, I have a procedure with one in parameter XMLTYPE deployed as a web service, I am getting error when I am trying to read the received XML data "namespace prefix "test" is not declared Error at line 1",

if i removed the "test:" from the xml (the red part in below example) it will work fine but this is can not be removed by the tool who is triggering the procedure as per middle ware team feedback

DB V: 11.2.0.2.0

XML V: 11.2.0.2.0

Procedure:

  PROCEDURE Test(Param1 IN VARCHAR2
                ,Param2 IN Xmltype
                ,Param4 OUT VARCHAR2) IS
  BEGIN
    SELECT Column_1
      INTO Param4
      FROM Xmltable('/' Passing Param2 Columns Column_1 VARCHAR2(100) Path
                    'PARAM2_D');
    IF Param4 IS NULL
    THEN
      Param4 := 'Null Value';
    END IF;
  END;

This is the the code used in calling the procedure:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:test="http://xmlns.oracle.com/orawsv/INTERFACE/INBOUND_SERVICES/TEST">
   <soapenv:Header/>
   <soapenv:Body>
      <test:TESTInput>
         <test:PARAM4-VARCHAR2-OUT/>
         <test:PARAM2-XMLTYPE-IN>
          <test:PARAM2_D>test2</test:PARAM2_D>
         </test:PARAM2-XMLTYPE-IN>
         <test:PARAM1-VARCHAR2-IN>test</test:PARAM1-VARCHAR2-IN>
      </test:TESTInput>
   </soapenv:Body>
</soapenv:Envelope>

Thanks ...