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>