Passing xml as a parameter to a proc is returning null

0

My xml may be wrong, of course. but as I'm not sure, I say: I need to pass a parameter via programming to a proc. As in my program it is coming null, I have decided to run first manually straight into pl / sql and still nothing comes. The xml mounted by the system looks like this:

    [0]: {<sCodPrestadorTs>1366348</sCodPrestadorTs>
}
    [1]: {<sCodPrestadorTsSub>3850055</sCodPrestadorTsSub>
}
    [2]: {<sCodRede>801</sCodRede>
}
    [3]: {<sCodOperadora>1</sCodOperadora>
}
    [4]: {<sDataExclusao>07/01/2016</sDataExclusao>
}

To pass the hand, I did so:

<sCodPrestadorTs>1366348</sCodPrestadorTs>
<sCodPrestadorTsSub>3850055</sCodPrestadorTsSub>
<sCodRede>801</sCodRede>
<sCodOperadora>1</sCodOperadora>
<sDataExclusao>07/01/2016</sDataExclusao>

And so I step on the proc proc. The type passed to string, as can be seen in the image.

What is wrong with this approach? I used the C # tag, because the application where the parameter is passed is in C # (web forms).

One of the errors is that there was no parent tag. I put it and got to run the proc and return something. This was the xml:

<parametros>
    <sCodPrestadorTs>1366348</sCodPrestadorTs>
    <sCodPrestadorTsSub>3850055</sCodPrestadorTsSub>
    <sCodRede>801</sCodRede>
    <sCodOperadora>1</sCodOperadora>
    <sDataExclusao>07/01/2016</sDataExclusao>
</parametros>
    
asked by anonymous 08.12.2015 / 11:58

0 answers