SQL Loader Help --

From: Dave Stienessen <davids_at_xata.com>
Date: Tue, 21 Sep 1999 18:53:07 -0400
Message-ID: <F4155D9F9AA4D111B9990020AFBA52D51E88BF@user62.sfi-software.com>

Hi,
I'm trying to load data into oracle from a sql server bcp character output file -- here's the specifics

The error I receive is:
SQL*Loader-524: partial record found at end of datafile (oraclloadopts.txt)

the table is defined as
create table OrderProduct
(

    OrderID               NUMBER(6)              not null,
    ShippingDate          DATE                   not null,
    ProductID             CHAR(10)               not null,
    UnitPrice             NUMBER(8,2)            not null,
    Quantity              INTEGER                not null,

)

Here's my control file contents:

OPTIONS (BINDSIZE=100000) LOAD DATA
INFILE 'ORDERPRODUCT.TXT'
BADFILE 'ORDERPRODUCT.BAD' INTO TABLE ORDERPRODUCT
FIELDS TERMINATED BY ','
-- hex code 27 is the single quote
OPTIONALLY ENCLOSED BY X'27'
(orderid, shippingdate DATE(23) "YYYY-MM-DD HH24:MI:SS", PRODUCTID, UNITPRICE,QUANTITY) Here's a sample record from the text file 78057,1976-04-15 07:44:12.000,' 0INT 0',656.37,5 Does someone know what I'm doing wrong?? Thanks
Dave Stienessen Received on Tue Sep 21 1999 - 17:53:07 CDT