Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tpiazza55
Posting Yak Master
162 Posts |
 Posted - 2010-06-18 : 11:31:22
|
| I have a stored procedure Im passing values to.the function that sends the information sent a weird value which caused it to fail.how do i catch this?The error is belowCould not find prepared statement with handle 0.sp_xml_removedocument: The value supplied for parameter number 1 is invalid.The XML parse error 0xc00ce51f occurred on line number 1, near the XML text "<rows><rowinfo TransactionID="52" Value="??f?#x3;?,?u~?#x1;?#x1;0#x0;" /></rows>".The statement has been terminated.Stored procedure@UpdateXML varchar(max) AS DECLARE @xmlHandle int EXEC sp_xml_preparedocument @xmlHandle OUTPUT, @UpdateXML update statement here with openxml EXEC sp_xml_removedocument @xmlHandle |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-06-18 : 12:10:22
|
| seems like the xml document passed was not well formed.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tpiazza55
Posting Yak Master
162 Posts |
Posted - 2010-06-18 : 13:32:04
|
| i pulled the xml line out that passed the strange value -- doc is well formed. it is just that weird value screwing things upthe error is an invalid unicode error |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-06-22 : 10:49:30
|
| how are you generating this xml?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
CrazyT
Yak Posting Veteran
73 Posts |
Posted - 2010-06-22 : 14:00:06
|
| .net replaces invalid unicode with a ? -- so maybe output isnt the real value that was passed |
|
|
|
|
|
|
openxml error