Re: SQL*Loader - what happened?

monicaroman_at_yahoo.com (Monica Roman) wrote in message news:<9eb77af5.0304080617.64b77cd5_at_posting.google.com>...
> Following-up on the message I sent earlier.
> I realized that I need to format the date field, so I loaded:
>
> Load data
> ...
> Fields terminated by ','
> (TBLDATE "DD-MM-YYYY HH24:MI:SS",
> TBLPRIORITY... etc.)
>
> But I got an error: SQL*Loader-291: Invalid bind variable MI in SQL
> string for column TBLDATE.
>
> I couldn't find references but one, unanswered, on the group. How is
> this resolved?
>
> Thanks!
>
> Monica

Hello,

I recently used this control file, may be you can use it as well.

LOAD DATA

INFILE 'out.EXTRBPO.1.key.txt'
BADFILE 'loader.bad.extrbpo.key.txt'
DISCARDFILE 'loader.discard.extrbpo.key.txt'

APPEND INTO TABLE KEYSGR1
FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"' (startsearchdate DATE 'yyyy/mm/dd',

 applid CHAR(20),
 fileid CHAR(5),
 keyid  CHAR(2),