Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    123

    Unanswered: Precisionproblem with ODBC and Oracle

    Hi!

    I have an accessdatabase that imports rawdata from several tables into several databases.

    The source is an Oracle database and I'm using odbc-links to connect to it in access.

    I get an errormessage when I try to insert into a number kolumn:
    "the decimal field's precision is too small to accept the numeric you attempted to add"

    I have tried to have the column as decimal with the same precision as in the odbclink, same fault.

    Any ideas as to what are causing this?

  2. #2
    Join Date
    Jul 2003
    Posts
    123
    Nobody?

    ttt

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Precisionproblem with ODBC and Oracle

    Originally posted by oneleg_theone
    Hi!

    I have an accessdatabase that imports rawdata from several tables into several databases.

    The source is an Oracle database and I'm using odbc-links to connect to it in access.

    I get an errormessage when I try to insert into a number kolumn:
    "the decimal field's precision is too small to accept the numeric you attempted to add"

    I have tried to have the column as decimal with the same precision as in the odbclink, same fault.

    Any ideas as to what are causing this?
    What is the type of the column inserting into? Float? Double? What is the type of the Oracle column? How big is it?

  4. #4
    Join Date
    Jul 2003
    Posts
    123
    The type of the column I'm inserting into are
    "decimal"
    Precicion: 15
    Scale: 5

    And the same if I look at the design of the odbclink. In Oracle it is:
    NUMBER(15,5)

    But I have found another "fun" problem.... When I select from a field that contains a float, I get funny numbers.

    Even when I look at numbers in a select query they are wrong!
    For example 345,2365 will come out as 3452365.

    What am I doing wrong?

    (I've posted this question as a separate tread)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •