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

 

 

31581500+1+117047911345480.55345480.55260523.04260523.04
31865742+1+11822774264849.39129698.7855424.11110848.22
31865796+1+118227772119627.78239255.56103052.4206104.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+21982416115551.8715545.8721296.5611296.56
25503474+1+31973321125552.8725235.8731392.5622216.56
51403445+5+11963732135553.8735225.8741216.5621291.56
42703476+1+41954543135554.8745515.8721292.5611236.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

Legend

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