Re: sqlldr question- imbed functions in sqlldr

I found a way to imbed functions using sqlldr at http://www.onwe.co.za/frank/faqloadr.htm and I put this line in:

   Date_typed "to_date(Date_typed, 'DD-MM-YY')"

Now it complains:
SQL*Loader-417: SQL string (on column DATE_TYPED) not allowed in direct path.
What this "direct path" refer to?

Any suggestion?

Zhiliang

Zhiliang Hu wrote:

> How would you include a function like "to_date" using SQL Loader
> (sqlldr)?
> I tried the following as my control file and it failed. Any suggestion
> is
> very appreciated!
>
> load data
> infile 'proc_data.txt'
> badfile 'proc_data.bad'
> discardfile 'proc_data.dsc'
> append into table genotest
> fields terminated by "#" optionally enclosed by '"'
> (PPID,
> Plate,
> location,
> Raw1,
> Raw2,
> Bk_grd,
> Read1,
> Read2,
> to_date ('Date_typed', 'DD-MM-YY'))
>
> Thanks in advance!
>
> Zhiliang
  Received on Wed Feb 28 2001 - 21:10:45 CET