the problem here is that i have written this control file LOAD DATA
APPEND INTO TABLE trap_ra_k1_ppb_balance
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
DATE_LOADED "(SELECT trunc(sysdate) FROM dual)",
WEEK_NO "(SELECT to_char(sysdate,'WW') FROM dual)",
RELOAD_DATE position (01:15) "to_date((:reload_date), 'yyyymmddhhmmss')",
note: the date_loaded and week_num is something that i populate by myself and is not in the stream
i cant seem to do it because there is something wrong with the date because it contains the time as well and also need to put the decimal point while uploading
anyone could help??