Re: Specifying the CLOBs in SQLLOADER control files

version is 10g,

control file is
LOAD DATA CHARACTERSET WE8EBCDIC1140
INFILE 'TGEN683.DAT' "FIX 4174"
INTO TABLE CGEN.TGEN683
TRUNCATE
TRAILING NULLCOLS
(
ITN_IDN_CDE POSITION( 1 )
CHAR( 4) ,
HKP_PCS_CDE POSITION( 5 )
CHAR( 4) ,
ETY_IDN_CDE POSITION( 9 )
CHAR( 4) ,
HKP_PCS_DTE POSITION( 13 )
DATE(10) "DD.MM.YYYY" ,
ETY_FLD_NBR POSITION( 23 )
SMALLINT ,
LST_UPD_DTE POSITION( 25 )
DATE(10) "DD.MM.YYYY" ,
LST_UPD_TME POSITION( 35 )
CHAR(8) ,
LST_UPD_UID POSITION( 43 )
CHAR( 8) ,
LST_UPD_NBR POSITION( 51 )
SMALLINT ,
ETY_FLD_TXT POSITION( 53 )
CLOB
)

syntax error is

SQL*Loader: Release 10.2.0.1.0 - Production on Sat Aug 12 06:39:35 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-350: Syntax error at line 26. Expecting valid column specification, "," or ")", found "CLOB". CLOB
^

Sybrand Bakker wrote:

> On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju_at_gmail.com wrote:
>
> >hi,
> >
> >i have a column of length 4211 from the DB2 which is already loaded
> >into the datafile in EBCDIC format.
> >
> >I am loading the data into the oracle tables using the charcter set
> >clause from EBCDIC to ASCII.
> >
> >when i specify a column with CLOB datatype i am getting a syntax error.
> >
> >
> >Please let me know how to load a colunm with CLOB data type in the
> >oracle databaase tabel.
> >
> >thanks
> >Ramesh
>
> Without
> - the Oracle version
> - the exact control file
> - the exact syntax error
>
> No one here will be capable to resolve your problem and you'd better
> not posted this three times.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sun Aug 13 2006 - 02:26:56 CDT