error: SQL Loader-466 column not exist ??? help !!!!

From: chijar <chijar_at_gmail.com>
Date: Thu, 10 Jan 2008 12:36:44 -0800 (PST)
Message-ID: <3601b3ae-6db1-4c74-acd6-3382854578d0@z17g2000hsg.googlegroups.com>


dear all.
i have a problem with sql loader.
The error is:
SQL*Loader-466: Column NUM_PAQ does not exist in table PLANELEC.file

i saw desc table:
SQL> DESC PLANELEC.file
Nombre żNulo? Tipo

----------------------------------------- --------
----------------------------

num_paq NOT NULL CHAR(8)
formulario NOT NULL CHAR(4)
norden NOT NULL NUMBER(38)
cod_docide_dec NOT NULL NUMBER(38)
num_docide_dec NOT NULL VARCHAR2(11)
num_correl_a NOT NULL NUMBER(38)
cod_docide_aseg NOT NULL NUMBER(38)
num_docide_aseg NOT NULL VARCHAR2(15)
cod_cat_tra NOT NULL NUMBER(38)
cod_tipo NOT NULL NUMBER(38)
fec_ini_perlab NOT NULL DATE
fec_fin_perlab DATE
cod_extincion CHAR(2)
ind_envio NUMBER(38)
fec_envio DATE
num_ctl CHAR(6)


****************

my ctl file is:
Load DATA
INFILE file.UNL
INSERT
INTO TABLE PLANELEC.file
fields terminated by '|'
TRAILING NULLCOLS
(
NUM_PAQ,FORMULARIO,NORDEN,COD_DOCIDE_DEC,NUM_DOCIDE_DEC,NUM_CORREL_A,COD_DOCIDE_ASEG,
NUM_DOCIDE_ASEG,COD_CAT_TRA,COD_TIPO,FEC_INI_PERLAB,FEC_FIN_PERLAB,COD_EXTINCION,
IND_ENVIO,FEC_ENVIO,NUM_CTL

)

and the first line of the file.unl is:
00000000|0601|2000043|6|20100066603|1|1|90000001|1|20|01/02/2002|||0|| 613954|

what could be the problem with that?

thanks a lot !
cesar

ORACLE 10GR2
RHEL AS V4.0 Received on Thu Jan 10 2008 - 14:36:44 CST

Original text of this message