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 :
*<add name="int16" value="edmmapping number(4,0)" />*

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 ( with Oracle Developer Tools for Visual Studio
- Visual Studio 2010 (C# / .net4)



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