Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Number Error for Decimal Field While Loading Data

585578Dec 23 2008 — edited Dec 23 2008
I am loading a delimited text file using the SQL* loader however I am reciving an error in my decimal fields. When a decimal field only has leading zeros before the decimal point I receive invalid number error. Below will clarify:

i.e.) 00000000.30 [*Invalid number*]
i.e.) 00046567.45 [*Valid number*]
i.e.) 00000001.00 [*Valid number*]

I've tried setting the precision/scale in the table, tried declaring it a decimal field instead of number, none of these methods fixed the issue. Any help I would really appreciate.
  POLICY_NUMBER        	NUMBER,
  EFFECTIVE_DATE	DATE "YYYYMMDD"		NULLIF EFFECTIVE_DATE = '',
  TRANSACTION_DATE	DATE "YYYYMMDD",
  TRANSACTION_AMOUNT	DECIMAL EXTERNAL,   -- Tried TRANSACTION_AMOUNT DECIMAL EXTERNAL (10)  & TRANSACTION_AMOUNT NUMBER
  MF_TRX_CODE		NUMBER,
  USER_ID		CHAR,
  GROUP_NUMBER		NUMBER,
  EXPIRATION_DATE	DATE "YYYYMMDD"		NULLIF EXPIRATION_DATE = '',
  BILL_NUMBER		NUMBER,
Any help is greatly appreciated. Thanks before hand.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2009
Added on Dec 23 2008
5 comments
2,152 views