SQL Loader question

[bheemsen]

Hi All,

I am using the following control file to load data into an oracle table (version 8.1.4).

LOAD DATA
APPEND
INTO TABLE FF_DA_TAPER_TERM
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
( WIRE_CNTR_CD,
WIRE_CNTR_NAME,
TAPER_CD "SUBSTRtaper_cd,1,6)",
SERVING_TRML_NAME,
SERVING_TRML_FUNCTION,
DA_CD,
LOOP_MEDIUM_TYPE,
CSA_NAME,
CSA_LENGTH,
SERVING_TRML_TYPE)

But I am getting the following error when I run the script.
SQL*Loader-417: SQL string (on column TAPER_CD) not allowed in direct path.

Can some one please help me what I am doing wrong here.
How else I can achieve this task using SQL Loader only ?

Thanx..
-Bheemsen

 

[rcurva]

You can not use a function when you are loading using DIRECT=Y. Use conventional instead.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War