Oracle Float

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Heavey (JimHeavey_at_discussions.microsoft.com)
Date: 11/11/04 

Date: Thu, 11 Nov 2004 06:31:02 -0800

Hello, I am calling an Oracle Stored Procedure. It has a column which is
defined as "Float". The Oracle procedure defines a parameter for this field
as "Float". In my program I create a parameter which is a Oracle DbType of
"Double". When I execute the procedure, it fails with an ORA 06502 and ORA
06512 and these error messages talk of not being able to convert propertly
from string to numeric.

When I look at the table, I see that my transaction did apply to the
database, inspite of the error message, but the Fields which is identified as
"float" and I defined a "Double" has the amount that I passed, but the value
truncates the last four decimal places - I passed 8 decimal positions but
only 4 remained.

Am I using the correct datatype in my program to describe a float value?
Any ideas as to why I am getting the Errors begin returned?
The output paramterters, when I create them in my program, - the "value"
portion of thos parameters, do they need be to initialized with "null" in the
"Value" property?

Thanks in advance for your assistance!!

Relevant Pages

  • Oracle Stored Procedure Problems
    ... I am calling an Oracle Stored Procedure. ... defined as "Float". ... 06512 and these error messages talk of not being able to convert propertly ... truncates the last four decimal places - I passed 8 decimal positions but ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: NUMBER(0) and NUMBER
    ... can be seen in turn as FLOAT? ... numeric precision specifier is out of range ... Oracle uses internal library routines to handle the data. ... data type and applys restrictions for the maximum and minimum allowed ...
    (comp.databases.oracle.misc)
  • Re: MSACCES.EXE to ORACLE via odbc implicit float number conversion
    ... The referenced columns are type number so a conversion takes place. ... Prior to 11g Oracle stores all numeric data as data type number. ... Oracle to only handle values that fit in a float. ...
    (comp.databases.oracle.server)
  • Re: MSACCES.EXE to ORACLE via odbc implicit float number conversion
    ... Perhaps there is someone with knowledge about MSACCESS and ORACLE. ... During 10046 level 12 tracing I saw bind variables type float ... Are there any issues regarding floats and numbers and ODBC to Oracle? ... Prior to 11g Oracle stores all numeric data as data type number. ...
    (comp.databases.oracle.server)
  • Re: Precision and ==
    ... puts "#: #" ... Float: 0.785398163397448 ... it rounds to 15 decimal positions: ...
    (comp.lang.ruby)