Re: sqlldr question- imbed functions fail

Thanks, Alexander! ... I tried it and now the complain becaomes:

SQL*Loader-930: Error parsing insert statement for column DATED.

Following an advice from "Harris Ruan" <h_ruan_at_totalise.com.au>, I used ' Dated Date "DD-MM-YY" ' at the trouble line and it worked (worked with the 'Direct=true' line).

Thank you all and have a nice day!

Zhiliang

"A. Bogomol" wrote:

> 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 - 08:59:28 CST