Home -> Usenet -> comp.databases.oracle -> problems with float data using C/Oracle ... please help

problems with float data using C/Oracle ... please help

From: DINESH PUNJABI <dpunjabi_at_nyx10.cs.du.edu>
Date: 1995/06/02
Message-ID: <3qnik1$9k4_at_nyx10.cs.du.edu>#1/1 






I am using a third party tool called persistence which interfaces with
the oracle database.



I am having problems inserting floating point numbers in an Oracle table:



Here is what I enter in my sample program and here is what gets stored in
the Oracle table:



Input Ascii Data file:





% cat Commission.Table.Data


CommRate, Months 


51.2312345, 22

32.1789, 12
123.998, 2
11.2223, 1





Oracle Table:





SQL> select * from corpapp_comm;



  COMMRATE     MONTHS



    
  
  •   ----------
  51.2312355         22
  32.1789017         12
  123.998001          2
  11.2222996          1






SQL> desc corpapp_comm;

   Name                            Null?    Type
   ------------------------------- -------- ----
   COMMRATE                        NOT NULL FLOAT(126)
   MONTHS                          NOT NULL NUMBER(38)





SQL> 




Essentially what I want is to store EXACTLY what is in the input data file.



Your email responses will be highly appreciated  .....



Rgds



Dinesh

-- 

Dinesh Punjabi 
dpunjabi_at_nyx.cs.du.edu                Work: (303)-624-9812


Received on Fri Jun 02 1995 - 00:00:00 CEST












Original text of this message