Re: SQL*Loader - newbie question

Paul Woods wrote in message <9%8G3.395$f4.1043_at_news1.iquest.net>...
>I'm sure there is a simple answer to this, but right now it's driving me
>nuts. I'm trying to use SQL*Loader to import a comma separated file into a
>table (Oracle 8i on NT).
>
>In an attempt to troubleshoot the problem, I have reduced my control file
>(test2.ctl) to this very simple example:
>
>LOAD DATA
> INFILE *
> REPLACE
>INTO TABLE TESTTABLE
>FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
>(FIRSTNAME, LASTNAME)
>BEGINDATA
>John,Doe
>
>However, no matter what I do, I always get the following error:
>
> SQL*Loader-524: partial record found at end of datafile (test2.ctl)
>
>I get that whether I use an external data file or I include the data in the
>control file. What in the world is causing this?
>
>Thanks,
>
>Paul
>
>

Off the top of my head.....

don't you need a trailing comma????

e.g.

>BEGINDATA
>John,Doe,

Just a thought.

Graham

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories. Received on Wed Sep 22 1999 - 14:17:06 CDT