Hi,

I am trying to load a numeric data which comes in the scientific notation using sqlloader.

My table has a std_cost which is Number (10,3). The scientific number is 1.202E007 (which is equivalent to 12020000) and the length is just 8.

If I load this data to my table (into number(10,3) field) it fails with

ORA-01438: value larger than specified precision allows for this column

However, If I increase the field length of std_cost to number(11,3) the load is succesful.

Could you please tell me what is the difference here.

Badrinath