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
