Re: sqlldr question- imbed functions fail

look through a command line.
I think your command line has the following parameter : 'Direct=TRUE'.
Remove it.

I think, it helps.

Alexander

Zhiliang Hu ïèøåò â ñîîáùåíèè <3A9ED80E.1792CBFA_at_genomicfx.com> ...
>I tried a "to_date" function in SQL Loader (sqlldr) with the
>control file as follows and it failed. Any suggestion is
>very much 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,
> Read1,
> Read2,
> Dated "to_date(Dated, 'DD-MM-YY')"
>)
>----------------------
>
>it complains:
>SQL*Loader-417: SQL string (on column DATE_TYPED) not allowed in direct
>path.
>
>Any suggestion to overcome this?
>
>Thanks in advance!
>
Received on Fri Mar 02 2001 - 02:17:39 CST