This discussion is archived
0 Replies Latest reply: Nov 12, 2012 2:32 AM by 973751 RSS

Use int32 for Oracle number(5): insert do not work correctly

973751 Newbie
Currently Being Moderated
Hi !
I am facing a problem of mapping with Oracle mapping with .Net.
By default, the mapping for a number(5) is int16 (short), where the number(5) can be much bigger (99999 VS 32767).
I searched a while and the only solution I found is to put this in the app.config and regenerate the edmx file :
*<oracle.dataaccess.client>*
*<settings>*
*<add name="int16" value="edmmapping number(4,0)" />*
*</settings>*
*</oracle.dataaccess.client>*

Well, I got the error 2019 error in VS2010, but it compile fine. Read data in database works fine, but I can't insert a number bigger than the max of a short. By example, if I try to insert 99999, when I look in the database, I found -31073.
I 'm not an expert and can't find anymore thing to do to make it works. Any help will be greatly appreciated.

Here is my config, if this could help :
- Windows 2003 server
- Oracle 10g database
- ODAC 11.2 Release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio
- Visual Studio 2010 (C# / .net4)

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points