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.
View Complete Post