Oracle database decimal problem

Topics: Data Access Application Block
Jun 7, 2007 at 7:17 PM
I have an application that needs to read a column from an Oracle table that has the value similar to 0.00374529040982141 if it has a value at all. I am using the Data Access Application Block from Ent Lib version 2.0 and I get an exception when I check to see there is anything in the column. The code I am executing is If dwAccount.Item("scorecurrmonth").Equals(System.DBNull.Value) Then .... The exception is listed below. The exception message is Exception Message; Decimal's scale value must be between 0 and 28, inclusive. Parameter name: scale. Any ideas on how to get around this? Thanks.

Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 5000
Date: 6/7/2007
Time: 7:36:04 AM
User: N/A
Computer: VMDOTNET1
Description:
EventType clr20r3, P1 selectdatawarehouseaccounts.exe, P2 1.0.0.0, P3 4667ebf6, P4 selectdatawarehouseaccounts, P5 1.0.0.0, P6 4667ebf6, P7 1d, P8 5a, P9 system.argumentoutofrange, P10 NIL.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 63 00 6c 00 72 00 32 00 c.l.r.2.
0008: 30 00 72 00 33 00 2c 00 0.r.3.,.
0010: 20 00 73 00 65 00 6c 00 .s.e.l.
0018: 65 00 63 00 74 00 64 00 e.c.t.d.
0020: 61 00 74 00 61 00 77 00 a.t.a.w.
0028: 61 00 72 00 65 00 68 00 a.r.e.h.
0030: 6f 00 75 00 73 00 65 00 o.u.s.e.
0038: 61 00 63 00 63 00 6f 00 a.c.c.o.
0040: 75 00 6e 00 74 00 73 00 u.n.t.s.
0048: 2e 00 65 00 78 00 65 00 ..e.x.e.
0050: 2c 00 20 00 31 00 2e 00 ,. .1...
0058: 30 00 2e 00 30 00 2e 00 0...0...
0060: 30 00 2c 00 20 00 34 00 0.,. .4.
0068: 36 00 36 00 37 00 65 00 6.6.7.e.
0070: 62 00 66 00 36 00 2c 00 b.f.6.,.
0078: 20 00 73 00 65 00 6c 00 .s.e.l.
0080: 65 00 63 00 74 00 64 00 e.c.t.d.
0088: 61 00 74 00 61 00 77 00 a.t.a.w.
0090: 61 00 72 00 65 00 68 00 a.r.e.h.
0098: 6f 00 75 00 73 00 65 00 o.u.s.e.
00a0: 61 00 63 00 63 00 6f 00 a.c.c.o.
00a8: 75 00 6e 00 74 00 73 00 u.n.t.s.
00b0: 2c 00 20 00 31 00 2e 00 ,. .1...
00b8: 30 00 2e 00 30 00 2e 00 0...0...
00c0: 30 00 2c 00 20 00 34 00 0.,. .4.
00c8: 36 00 36 00 37 00 65 00 6.6.7.e.
00d0: 62 00 66 00 36 00 2c 00 b.f.6.,.
00d8: 20 00 31 00 64 00 2c 00 .1.d.,.
00e0: 20 00 35 00 61 00 2c 00 .5.a.,.
00e8: 20 00 73 00 79 00 73 00 .s.y.s.
00f0: 74 00 65 00 6d 00 2e 00 t.e.m...
00f8: 61 00 72 00 67 00 75 00 a.r.g.u.
0100: 6d 00 65 00 6e 00 74 00 m.e.n.t.
0108: 6f 00 75 00 74 00 6f 00 o.u.t.o.
0110: 66 00 72 00 61 00 6e 00 f.r.a.n.
0118: 67 00 65 00 20 00 4e 00 g.e. .N.
0120: 49 00 4c 00 0d 00 0a 00 I.L.....