Re: sqlldr Token length error...
From: FC <flavio_at_tin.it>
Date: Wed, 07 May 2003 06:43:32 GMT
Message-ID: <oW1ua.94429$K35.2623217_at_news2.tin.it>
Date: Wed, 07 May 2003 06:43:32 GMT
Message-ID: <oW1ua.94429$K35.2623217_at_news2.tin.it>
"Carol" <candrews_at_choiceonecom.com> wrote in message
news:26fd548c.0305060438.1630acd7_at_posting.google.com...
> Hi,
> I'm trying to use a decode statement in my sqlldr control file. It
> is longer than the max allowed token length as is evident by the error
> msg - 'Token longer than the max allowable length of 258 chars'. Has
> anyone run into this and how did you handle it, is there a workaround
> for this?
>
> Thanks
> - Carol
I guess you can try creating a user defined function where you perform all
the DECODEs you wish.
Then you call this function in the control script.
Otherwise you can handle everything inside a BEFORE INSERT trigger.
Bye,
Flavio
Received on Wed May 07 2003 - 08:43:32 CEST