SQL*Loader: Release 10.1.0.5.0 - Production on Tue Mar 10 06:45:54 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: t1.ctl Data File: /home/appltest/Sheet1.csv Bad File: sample.bad Discard File: sample.dsc (Allow all discards) Number to load: ALL Number to skip: 3 Errors allowed: 10000 Bind array: 64 rows, maximum of 256000 bytes Continuation: none specified Path used: Conventional Table SAMPL_TABLE, loaded from every logical record. Insert option in effect for this table: REPLACE TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- CUSTOMER_NAME FIRST * , O(") CHARACTER NULL if CUSTOMER_NAME = BLANKS SQL string for column : "RTRIM(:customer_name)" CUSTOMER_NO NEXT * , O(") CHARACTER NULL if CUSTOMER_NO = BLANKS SQL string for column : "RTRIM(:customer_no)" ITEM_NO NEXT * , O(") CHARACTER NULL if ITEM_NO = BLANKS SQL string for column : "RTRIM(:item_no )" VALID_AMOUNT_MONTH1 NEXT * WHT O(") CHARACTER NULL if VALID_AMOUNT_MONTH1 = BLANKS SQL string for column : "to_number(:valid_amount_month1 , '999,999,999.99')" VALID_UNITS_MONTH1 NEXT * WHT O(") CHARACTER NULL if VALID_UNITS_MONTH1 = BLANKS SQL string for column : "to_number(substr(:valid_units_month1,instr(:valid_units_month1,'$')+1),'999,999,999.99')" VALID_BUDGET_UNITS_MONTH1 NEXT * WHT O(") CHARACTER NULL if VALID_BUDGET_UNITS_MONTH1 = BLANKS SQL string for column : "to_number(:valid_budget_units_month1, '999,999,999.99')" VALID_BUDGET_AMOUNT_MONTH1 NEXT * WHT O(") CHARACTER NULL if VALID_BUDGET_AMOUNT_MONTH1 = BLANKS SQL string for column : "to_number(trim(substr(:valid_budget_amount_month1,instr(:valid_budget_amount_month1,'$')+1)),'999,999,999.99')" VALID_RATE NEXT * , O(") CHARACTER NULL if VALID_RATE = BLANKS SQL string for column : "RTRIM(:valid_rate)" Record 1: Rejected - Error on table SAMPL_TABLE, column VALID_AMOUNT_MONTH1. ORA-01722: invalid number Record 2: Rejected - Error on table SAMPL_TABLE, column VALID_AMOUNT_MONTH1. ORA-01722: invalid number Record 3: Rejected - Error on table SAMPL_TABLE, column VALID_AMOUNT_MONTH1. ORA-01722: invalid number Table SAMPL_TABLE: 0 Rows successfully loaded. 3 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Space allocated for bind array: 132096 bytes(64 rows) Read buffer bytes: 1048576 Total logical records skipped: 3 Total logical records read: 3 Total logical records rejected: 3 Total logical records discarded: 0 Run began on Tue Mar 10 06:45:54 2015 Run ended on Tue Mar 10 06:45:54 2015 Elapsed time was: 00:00:00.06 CPU time was: 00:00:00.00