sqlldr question- imbed functions fail

From: Zhiliang Hu <zhu_at_genomicfx.com>
Date: Thu, 01 Mar 2001 17:15:26 -0600
Message-ID: <3A9ED80E.1792CBFA@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 Thu Mar 01 2001 - 17:15:26 CST