Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Loading negative number using SQL*Loader
Hi all,
My input file looks like this:
99999|10|94|1090|229554.00 99999|10|95|-10|-2106.00 601150|5|81|10|1290.00 601150|5|82|10|1290.00
And the control file is:
LOAD DATA
INFILE 'E:\Amgen\TB_FCT_DDD_ACCT_NDC_MTH.txt'
INTO TABLE oncdata.TB_FCT_DDD_ACCT_NDC_MTH
( OUTL_ID decimal EXTERNAL terminated by '|', PROD_NDC_ID decimal EXTERNAL terminated by '|', TIME_MTH_CD decimal EXTERNAL terminated by '|',FCT_DDD_ACCT_UNITS decimal EXTERNAL terminated by '|', FCT_DDD_ACCT_DLLR packed decimal external(10,2))
Somehow, SQL*Loader rejects the negative numbers:
99999|10|95|-10|-2106.00 627000|9|81|-10|-1290.00 698000|9|93|-40|-5288.00 731000|5|76|-20|-2580.00
Any help is appreciated Received on Fri Mar 19 1999 - 22:36:13 CST
![]() |
![]() |