Re: sqlldr question- imbed functions in sqlldr
From: Matt B. <mcb_at_ds.znet.com>
Date: Wed, 28 Feb 2001 20:39:21 -0800
Message-ID: <t9rlfrjqh925b0_at_corp.supernews.com>
Date: Wed, 28 Feb 2001 20:39:21 -0800
Message-ID: <t9rlfrjqh925b0_at_corp.supernews.com>
"Zhiliang Hu" <zhu_at_genomicfx.com> wrote in message
news:3A9D5B45.9746163E_at_genomicfx.com...
>
> 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?
You're running it from the command line in direct path mode. Remove that parameter.
-Matt Received on Thu Mar 01 2001 - 05:39:21 CET