Re: newbie question about SQL Loader

<" srcnckpc"_at_hotmail.com> wrote in message news:3A8E4C67.BED9DE51_at_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
>

Looks like you have the following problem a) your table definition expects both columns to be not null/mandatory b) there are several blank lines in the file test.txt

However, without looking at the exact table definition and (part of) test.txt
your problem is difficult to resolve.
Note: as per your definition you expect test.txt to have a fixed record length. If that isn't true you can expect all kind of mysterious problems, because Sql*loader will simply apply the masks in the control file.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Feb 17 2001 - 19:23:56 CET