Devart Forums

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);
                }