| Thiago Oliveira Vieira de Morais 2005-08-03, 11:24 am |
| Good morning,
Iīm testing the SQL 2k5 and during the execution of an stored procedure i
get the error below:
System.Data.SqlClient.SqlException: Incoming . Parameter 6
('@JudgmentPrincipal
1Interest'): Data type 0x6C has a invalid data
specified.
I found this document on the internet
http://download.microsoft.com/downl...eSQLEXP2005.htm
that says:
6.5 Common Language Runtime User-Defined Types Should Have Only One
Serialization
There must be only one serialization of a user-defined type (UDT) object. If
the serialize or de-serialize routines recognize more than one
representation of a particular object, you may see errors in the following
cases:
During validation of a UDT passed through RPC, UDT validation performs
de-serialization/re-serialization of the UDT and requires that the resulting
bytes be exactly the same as the original. If the validation fails, you will
see the error: "System.Data.SqlClient.SqlException, Incoming TDS RPC
protocol stream is incorrect. Parameter 1 ('@udt'): Data type 0xF0 has
invalid data specified."
During DBCC, the bytes stored in a UDT column must be equal to the computed
serialization of the UDT value. If this is not true, the DBCC CHECKTABLE
routine will report a consistency error.
I already tried this and didnīt work.
Does anyone know something about this error?
Thanks in advance.
Thiago Oliveira
MCAD
|