961857 wrote:That's one of those error messages that actually means what it says.
I am facing an error with message ''invalid number'' when trying to insert data through sql loader
Record 2: Rejected - Error on table "RPM_STAGE_PROMO_COMP_SIMPLE", column TIMEBASED_DTL_IND.Whatever was supposed to go into TIMEBASED_DTL_IND could not be converted to a number.
ORA-01722: invalid number
Bad File: /xtradb/RPMBULKUPLOAD/NICE_BULK_PROMOTION_TEMPLATE_6.badThe "Bad File" contains copies of all the rows from the dta file where this happened. Look at that column to see why it is happening.