Code: Select all
Unhandled Exception: System.ArgumentOutOfRangeException: Decimal's scale value must be between 0 and 28, inclusive.
Parameter name: scale
at System.Decimal..ctor(Int32 lo, Int32 mid, Int32 hi, Boolean isNegative, Byte scale)
at Devart.Data.Oracle.OracleNumberUtils.ToDecimal(Byte[] , Int32 )
at Devart.Data.Oracle.OracleBufferConverter.GetValue(Byte[] , Int32 , Int32 )
at Devart.Data.Oracle.OracleDataReader(Int32 )
at Devart.Data.Oracle.OracleDataReader.GetValue(Int32 i)
Code: Select all
OracleCommand command = connection.CreateCommand("SELECT TODONEUENTWICKLUNG, TECNOTIZ, TECNOTIZ2, KNDNOTIZ, KNDNOTIZIT, KNDNOTIZEN, KNDNOTIZUEB, PROGNOTIZ, UESTZNOTIZ, FAKTNOTIZ, VERSIONSLISTE, TODOAUFRECHANFUEHREN, TODOAUSLIEFERUNG, TODOBEMERKUNG FROM ADO_TODO_TEST WHERE todokode = 127986",
CommandType.Text);
command.Prepare();
var reader = command.ExecuteReader(CommandBehavior.SingleResult);
reader.Read();
reader.Dispose();
reader = command.ExecuteReader(CommandBehavior.SingleResult);
reader.Read();
for (var i = 0; i < reader.FieldCount; i++)
{
var val = reader.GetValue(i);
}
I have send you an test project with the contact formular. There exists an script folder with the table and data definition