Re: sqlldr question- imbed functions in sqlldr

From: Zhiliang Hu <zhu_at_genomicfx.com>
Date: Thu, 01 Mar 2001 12:26:37 -0600
Message-ID: <3A9E945D.15E4B92E_at_genomicfx.com>


Matt - Thank you for answering my question. But which "parameter" to remove? I tried a few different combinations and they still got the same error mesg.

Zhiliang

"Matt B." wrote:

> "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 - 19:26:37 CET

Original text of this message