Tech Off Thread

4 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

ODBC Data provider & 64bit oracle client: arithmetic operation resulted in an overflow

Back to Forum: Tech Off
  • User profile image

    I am currently trying to migrate an application off of the Oracle data provider and onto the Odbc provider. 


    Everytrhing seems like it should be working and the transiotion was (until now) very straightforward as i'm using no  oracle specific features and only executting very simplwe select statements with a couple joins. I have done this sort of thing before without issue but that was back in .Net 3x on x86 architectures. Now i'm trying this with Oracle 11g 64bit client, .net 4.0 on a 64bit system.


    Everything compiles, connections open, commands created then on ExecuteReader (or DataAdapter.fill() as i've tried both) I get the following error:


    "arithmetic operation resulted in an overflow"


    I've looked EVERYWHERE and have tried EVERYTHING i can think of. I've even tried running this all inside an unchecked{} block to no avail. This seems to be a topic on plenty of forums:



    But there are no real answers anywhere.

    ANY help, hack or workaround would be awesome!


  • User profile image

    what are the datatypes in this ???

    i would think that you might have somewhere a mis-match like say in .net if you had a an INT but if oracle was sending back a UINT or a LONG then you will have an overflow on conversion or something like that.

  • User profile image

    What are you pulling back? It sounds like one of the values is bigger than System.Decimal can hold.

  • User profile image

    @Jimi2Cool: are you able to solve this problem ?

    i am into the same issue can you please help me

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.