Last post Sep 06, 2017 06:56 PM by march11
Apr 14, 2011 01:32 PM|nideeshm|LINK
I have a stored procedure that accepts xml as input, and consequently calls the second procedure which again has xml as input.
For validating the input xml, I have created two schemas one for each of the procedure. The schema of outer procedure is slightly big one. The schema of second procedure is a subset of the first schema.
while trying to execute, I am getting an error, "Implicit conversion between XML types constrained by different XML schema collections is not allowed."
The main procedure is exposed to other applications, The main procedure will internally call other procedures. That is why i have to ensure that while calling the main procedure, they should not have any extra input coming in to main one.
Sep 06, 2017 06:56 PM|march11|LINK
I think this error means that the datatype you are reading into the schema does not match the type being sent in from the XML file.
You will need to try and turn on tracing and locate the record that is faulting and on which line of code.