0 Replies Latest reply: Nov 12, 2012 4:32 AM by 973751 RSS

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

    973751
      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.