Can anyone explain why I can't get these values to insert into my tables using a created data page in one of my APEX applications. The error I get is "ORA-01481: invalid number format model". I am able to insert these values manually by inserting a row in the object browser. This happens when importing a CSV or a tab separated list. I'm using APEX 4.1
| 31581500+1+1 | 1704791 | 1 | 345480.55 | 345480.55 | 260523.04 | 260523.04 |
| 31865742+1+1 | 1822774 | 2 | 64849.39 | 129698.78 | 55424.11 | 110848.22 |
| 31865796+1+1 | 1822777 | 2 | 119627.78 | 239255.56 | 103052.4 | 206104.8 |
The columns are Unit_ID,Work_ID,quantity,cost1,cost2,cost3,cost4
Unit_ID and Work_ID are both Varchar2(30) and the quantity and costs are all number. Strange thing is that I have similar values that pass and are inserted no problem within the same csv. A few examples of values that do work are:
| 11703473+1+2 | 1982416 | 1 | 15551.87 | 15545.87 | 21296.56 | 11296.56 |
| 25503474+1+3 | 1973321 | 1 | 25552.87 | 25235.87 | 31392.56 | 22216.56 |
| 51403445+5+1 | 1963732 | 1 | 35553.87 | 35225.87 | 41216.56 | 21291.56 |
| 42703476+1+4 | 1954543 | 1 | 35554.87 | 45515.87 | 21292.56 | 11236.56 |
Looking at it it seems the ones over 100k are failing but as far as I know I have no such restriction. My precision and scales in the object browser are blank.
Thanks,
-Steve
