Re: {URGENT} SQL Loader Help!!

In your CONTROL file,
explicitly define the date field

e.g.,
LOAD DATA
...
FIELDS TERMINATED ...
(

	NAME 
	, DATE INTEGER EXTERNAL

Lemme know if this works.

Cheers
Shanx

---
Shashank Tripathi
http://shanx.com

On Thu, 25 Nov 1999 01:36:27 GMT, Billy Collins <billy_collins_at_my-deja.com> wrote:

>Thanks all for the help!! Much appreciated.
>Now, I have another problem for which I cannot find documentation help.
>In my PIPE delimited text file, I have the following text
>----
>FER | 19/12/1999
>BILLY | 10/12/1999
>---
>
>I want to insert the date field into oracle. How do I do it? It gives
>me
>"Maximum length exceeded for the date field"
>
>!!!
>
>
>Please help!
>
>Thanks a lot in advance for all your timely help!!!
>
>Billy
>
>
>
>
>
>In article <jv47OFrSYjDcljk6da2cGZzhPNOT_at_4ax.com>,
> Fer <ferjaiXXXX_at_latinmail.com> wrote:
>>
>>
>> >What could be the problem here? Actually its a bit perplexing to
>> >me..how does one use SQLLDR80 to understand which Database you wish
>to
>> >connect to? Can I specifically specify it in the command line prompt
>> >(MSDOS)?
>>
>> Try
>>
>> sqlldr80 userid/Password_at_databasename control=mine.ctl log=mine.log
>>
>> Fer
>>
>
>--
>
>Good day
>Billy
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Nov 24 1999 - 22:15:58 CST