Need 1st time help with SQL Loader...

Hello all!!

I am trying to understand how to load a Personal Oracle 7.3 database via SQL Loader. I have the database up and running, SQL net, etc. I have created a simple table called JOETABLE. It has 3 fields: FNAME char 10, LNAME char10 and ADDRESS char 50. I have a joe.ctl file with the following:

LOAD DATA INFILE 'joe.dat' INSERT INTO TABLE JOETABLE FIELDS TERMINATED BY
"," OPTIONALLY ENCLOSED BY '"'

( "FNAME"    CHAR(10),
  "LNAME"    CHAR(10),
  "ADDRESS"  CHAR(50))

The data file (joe.dat) looks like this:

"FNAME","LNAME","ADDRESS"
"Kelly","Grigg","AR"
"Lester","Tester","TX"
"Chris","Suttle","state"

When I try to run imp kgrigg/kgrigg parfile=c:\temp\joe.ctl

I get the following errors,

LCC-00113: integer conversion error or negative integer [DATA] LCC-00218: error in file [c:\temp\joe.ctl] LCC-00217: failure while processing file parameter [parfile]

and a couple of IMP-##### errors dealing with import terminating. Can anyone give me some pointers or tell me where to look for some more literature on the syntax I should be using?

By the way, the joe.dat file is also in c:\temp directory...I have tried putting the whole path in the INFILE, as a matter of fact, I have tried many different variations of the above and still get the same error messages.

Any/All help appreciated!!

TIA, Kelly kgrigg_at_acxiom.com Received on Thu Apr 24 1997 - 00:00:00 CDT