This discussion is archived
0 Replies Latest reply: Sep 10, 2013 10:58 AM by switbeck RSS

Strange Datatype Problem

switbeck Newbie
Currently Being Moderated

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





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:




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.





  • Correct Answers - 10 points
  • Helpful Answers - 5 points