newbie needs help with SQL Loader

[" src...@hotmail.com]

Hello:

Here's my control file:

load data
infile 'test.txt'
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

[j_beverly]

I'm a beginner myself, but I'd suggest you look at the answers to
these questions and if you don't find the reason for the problem, post
more details and ask again.

How many fields do you have in your table and what are they? (Why
do you only have "Cusip" and "Issuer_name" in your control file,
but your error refers to a "ISSUE_DATE"?)

Do any of the records load? (e.g. 2-3 & 5-10)

What does the data (in 'test.txt') look like? Is there valid data
there for any fields with a NOT NULL constraint?

===============