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!