trying to load a .csv file into an oracle table with sql loader . keep getting errors on the numeric column
table is defined as
txn_id number(10)
user_id varchar(10)
location varchar(10)
purchase_amount number(7,2)
data looks like this
964859,000456789E,BSP,0000300
.ctl looks like this
fields terminated by ','
(vpur_transaction_id ,
SBI ,
AGY_LOC_ID,
Purchase_amount integer
)
Error says: Record 1: Rejected - Error on table OMS_OWNER.NJ_VPAY_PURCHASES, column PURCHASE_AMOUNT.
ORA-01438: value larger than specified precision allowed for this column
Anybody have any any ideas?
I also tried this for the purchase amount
Purchase_amount integer “:PURCHASE_AMOUNT/100”