Re: sql loader problem

david wendelken wrote:

> LOAD DATA
> INFILE '1244.csv'
> BADFILE '1244.bad'
> DISCARDFILE '1244.dsc'
> APPEND
> INTO TABLE ltest REPLACE
> FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
> (DATACALL INTEGER(2)
> ,QUESTIONID INTEGER(10)
> ,ORGID INTEGER(10)
> ,ANSWER01 VARCHAR
> ,ANSWER02 VARCHAR
> )

Off the top of my head (not having used sqlldr in a while, is "VARCHAR" even valid? Maybe try it with "CHAR" instead, or omit the datatypes altogether.

-- 
Bricklen Anderson, Database Administrator
PresiNET Systems
http://www.PresiNET.com
Online Demo: https://www.presinet.com/secure/login

_______________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than the
intended recipient is unauthorized. If you have received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------