Re: SQL*Loader - what happened?
Date: Tue, 08 Apr 2003 14:58:16 -0500
Message-ID: <v9a69vgu5245rh3tm3j6vq88sns9ua3o32_at_4ax.com>
monicaroman_at_yahoo.com (Monica Roman) wrote:
>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
Try to specify that date in your .ctl files like this:
TBLDATE DATE 'dd-mm-yyyy hh24:MI:SS'
(Note single quotes )
With a date field, you should also handle NULLS with a NULLIF statement ...
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Tue Apr 08 2003 - 21:58:16 CEST