newbie question about SQL Loader

From: <">
Date: Sat, 17 Feb 2001 15:54:57 GMT
Message-ID: <3A8E4C67.BED9DE51_at_hotmail.com>

Hello:

[Quoted] Here's my control file:

load data
infile 'test.txt'
[Quoted] into table excel

( Cusip  position(01:17)               char,
 Issuer_name  position(18:28)     char )

I get the following errors:

Record 11: Discarded - all columns null.
Record 12: Discarded - all columns null.
Record 13: Discarded - all columns null.

Record 1: Rejected - Error on table EXCEL. ORA-01400: cannot insert NULL into ("SCOTT"."EXCEL"."ISSUE_DATE")

Record 4: Rejected - Error on table EXCEL, column CUSIP. Column not found before end of logical record (use TRAILING NULLCOLS).

If I do 'not null' then I get errors saying 'syntax error....not null....."

Is the format 'test.txt' wrong? What other format can I use

Thanks so much,
SRC Received on Sat Feb 17 2001 - 16:54:57 CET