qlldr userid=SYSTEM/manager control=C:\kanaLONGfiletest/LONGControlFile.ctl
data=LONGControlFile.dat

THE SAMPLE DATA TO INSERT:
23 24 25 26 THIS TOOK ENTIRELY TOO DAMN LONG



THE COMMAND PROMPT SYNTAX IM USING IS:
sqlldr userid=SYSTEM/manager control=C:\kanaLONGfiletest/LONGControlFile.ctl
data=LONGControlFile.dat

THE TABLE I CREATED TO RECEIVE THE DATA IS:
SQL> DESCRIBE KC_RAWTEXT_TEST;
Name Null? Type
----------------------------------------- -------- --------------
MESSAGEID NUMBER(38)
TYPE NUMBER(38)
COMPRESSLEVEL NUMBER(38)
RAWTEXTID NUMBER(38)
VALUE LONG

THE CONTROL FILE IS:
LOAD DATA
INFILE 'kc_rawtext'
INTO TABLE kc_rawtext
FIELDS TERMINATED BY X'09'
(messageid integer, type integer, compresslevel integer, rawtextid
integer, value long)

THE ERROR IM RECEIVING IS
C:\ORACLE>sqlldr userid=SYSTEM/manager
control=C:\kanaLONGfiletest/LONGControlFi
le.ctl

SQL*Loader: Release 8.1.6.0.0 - Production on Tue Jul 31 19:26:11 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL*Loader-350: Syntax error at line 7.
Expecting keyword VARRAW, found ")".
presslevel integer, rawtextid integer, value long)

^

my problem:
I cannot use long raw ..only long is acceptable to the application

please help.


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Oracle LazyDBA home page