SQL*Loader - newbie question

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 Received on Wed Sep 22 1999 - 13:14:06 CDT