SQL Loader Help --

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

Hi,
[Quoted] [Quoted] I'm trying to load data into oracle from a sql server bcp character output [Quoted] 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
(

[Quoted]     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 Wed Sep 22 1999 - 00:53:07 CEST