Problem with SQL*Loader 8.0.3 1

[Kenrae]

Hi all. I have a problem with this aplication. It doesn't end. I was executing it from forms and the program waited for it eternally. Then I tried to execute it manually (I work with Windows 2000 professional) and it didn't end. It didn't return to the shell. And I don't receive any error.
I don't think it's a control file error, but I'll paste it here:

LOAD DATA
INFILE es.dat
APPEND
INTO TABLE P_M
(
a TERMINATED BY ',' "LTRIMmove_employee_number,'0')",
b TERMINATED BY ',',
c TERMINATED BY ',',
d TERMINATED BY ',',
e CONSTANT 'C',
f CONSTANT 'ES',
g TERMINATED BY ',',
h TERMINATED BY ',',
i TERMINATED BY ',',
j TERMINATED BY WHITESPACE
)

Any idea?

Thank's

 

[MikeJones]

I've never written my SQL Loader control files like this, but you appear to be missing the datatypes of every column,

also I'd write it like this any way, could you try this and post the result....

LOAD DATA
INFILE es.dat
INTO TABLE P_M APPEND
FIELDS TERMINATED BY ','
(
a datatype_here "LTRIMmove_employee_number,'0')",
b datatype_here,
c datatype_here,
d datatype_here,
e CONSTANT "C",
f CONSTANT "ES",
g datatype_here,
h datatype_here,
i datatype_here,
j datatype_here)

 

[Kenrae]

Well, I've tried your control file and... it loads the data! BUT, the process still doesn't end...
Then, I realised that I was working with SQL*Loader release 8.0.3 and our DB is an Oracle release 8.1.6. I've installed the newer version of SQL*Loader and... it ends!
Ufff, thanks for the answer.