Hi folks,
This may or may not be an iBatis issue.
When I try to insert a .net Decimal value into an Oracle decimal
column, I get this error: "numeric precision specifier is out of range
(1 to 38)". I googled it and found lots of advice to increase the
precision on the database. I've been fiddling with it for a bit but I
can't get it to work. These aren't currently big numbers either. My
test data for now is stuff like "1.23".
Anyone know why? Seems like an Oracle driver issue to me. Something to
do with the .NET Decimal datatype being too much precision for the table
even though the data isn't?
Some data:
- I can insert a simple value (1.23) using SQL directly.
- When I change my .NET datatype to a double it works
- I made iBatis output the SQL it's using, and everything looks fine.
The SQL runs.
Also note that I have no idea if I really need to use a Decimal type in
my .NET code, but it seems appropriate since I'll be doing a lot of
calcuations using this data and I don't want all of the precision and
rounding issues that come with float or double. Advice?
Much thanks,
Dustin
