Re: newbie needs help with SQL Loader

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?

On Fri, 16 Feb 2001 19:56:30 GMT, " srcnckpc"@hotmail.com wrote:

>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
>
Received on Sat Feb 17 2001 - 19:01:49 CST