SQL*Loader error

From: <invinfo_at_my-deja.com>
Date: Tue, 05 Dec 2000 20:57:02 GMT
Message-ID: <90jkqr$o2f$1@nnrp1.deja.com>

I'm getting SQL*Loader-524 error
partial record found at end of datafile

Of the 3 types of record formats, (Stream, Fixed, Variable), I'm trying to use Variable.

my .ctl file looks like this:

load data
infile 'rjk_dat.txt' "var"
badfile 'rjk_dat.bad'
discardfile 'rjk_dat.dsc'
discardmax 999
truncate
into table rjkdata
fields terminated by ","
(ndx,
name,
dscp)

I've also tried variations, including the TRAILING NULLCOLS clause.

One of my logs listed this:
Record 1: Rejected - Error on table RJKDATA, column NDX. ORA-01722: invalid number

Here are a couple lines of data:

1,login,Login error
2,databs,Database error
3,notes,Notes error


SQL>desc rjkdata
 Name                            Null?    Type
 ------------------------------- -------- ----
 NDX                                      NUMBER(6)
 NAME                                     VARCHAR2(25)
 DSCP                                     VARCHAR2(50)

Suggestions?
I'm currently looking for resources in Technet and in the Utilities Documentation. TIA for your help.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 05 2000 - 14:57:02 CST