https://bugzilla.novell.com/show_bug.cgi?id=382589
Summary: Passing either Decimal.Max or Decimal.Min to a SQL Server 2005 stored procedure that takes a decimal(29,0) results in a SqlException Product: Mono: Class Libraries Version: 1.9.0 Platform: All OS/Version: All Status: NEW Severity: Normal Priority: P5 - None Component: Sys.Data.SqlClient AssignedTo: mono-bugs@lists.ximian.com ReportedBy: [EMAIL PROTECTED] QAContact: mono-bugs@lists.ximian.com Found By: --- System.Data.SqlClient.SqlCommand cmd; System.Data.SqlClient.SqlParameter pValue; .. pValue = new SqlParameter("@value", Decimal.Max); cmd.Parameters.Add(pValue); cmd.ExecuteNonQuery(); System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 ("@value"): The supplied value is not a valid instance of data type decimal. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. at System.Data.SqlClient.SqlConnection.ErrorHandler (System.Object sender, Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e) [0x00000] at Mono.Data.Tds.Protocol.Tds.OnTdsErrorMessage (Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e) [0x00000] at Mono.Data.Tds.Protocol.Tds.ProcessMessage (TdsPacketSubType subType) [0x00000] at Mono.Data.Tds.Protocol.Tds.ProcessSubPacket () [0x00000] at Mono.Data.Tds.Protocol.Tds.NextResult () [0x00000] at (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:NextResult () at Mono.Data.Tds.Protocol.Tds.SkipToEnd () [0x00000] at (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:SkipToEnd () at Mono.Data.Tds.Protocol.Tds70.ExecRPC (System.String rpcName, Mono.Data.Tds.TdsMetaParameterCollection parameters, Int32 timeout, Boolean wantResults) [0x00000] at Mono.Data.Tds.Protocol.Tds70.ExecProc (System.String commandText, Mono.Data.Tds.TdsMetaParameterCollection parameters, Int32 timeout, Boolean wantResults) [0x00000] at System.Data.SqlClient.SqlCommand.Execute (CommandBehavior behavior, Boolean wantResults) [0x00000] at System.Data.SqlClient.SqlCommand.ExecuteNonQuery () [0x00000] -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. You are the assignee for the bug. _______________________________________________ mono-bugs maillist - mono-bugs@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-bugs