Hello All,
I am having a dilenma with sql loader. Upon attempting to load data All of my data is being sent to my discard file.I am receiving the following error message in my log.
rejected - Error on table FABBKTP, column FABBKTP_TRANS_DATE.
ORA-00911: invalid character
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table FABBKTP:
0 Rows successfully loaded.
51 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.
This is a copy of my control file.
LOAD DATA
INFILE 'BankRecon2.prn'
BADFILE 'bankrecon.bad'
DISCARDFILE 'bankrecon.dsc'
INTO TABLE FABBKTP APPEND
WHEN FABKTP_CHECK_DEPOSIT_CODE != BLANKS AND
FABBKTP_TRANS_DATE != BLANKS AND
FABBKTP_AMT != BLANKS
(
FABBKTP_BANK_CODE CONSTANT 'HC',
FABKTP_CHECK_DEPOSIT_CODE POSITION(0001:0008) CHAR "DECODE(TRIM(:FABKTP_CHECK_DEPOSIT_CODE), NULL, NULL, '', NULL, TRIM(:FABKTP_CHECK_DEPOSIT_CODE))",
FABBKTP_CHECK_DEPOSIT_IND CONSTANT 'C' ,
FABBKTP_TRANS_DATE POSITION(0011:0020) CHAR "TO_DATE(TRIM(:FABBKTP_TRANS_DATE),‘DD-MON-YY’)",
FABBKTP_TAPE_DATE SYSDATE,
FABBKTP_AMT POSITION(0021:0031) CHAR "TO_NUMBER(TRIM(:FABBKTP_AMT))",
FABBKTP_DESC CONSTANT 'Check Reconciliation From Bank Tape Load- July 2003')
Please Help!