Re: SQLLDR : Terminators

"Geoffrey Dufour" <g.dufour_at_swing.be> wrote in message news:<3b554161$0$4566$ba620e4c_at_news.skynet.be>...
> Hi,
>
> It is said in the SQL*LOADER Control File Reference Documentation that
> Termminators are strings not limited to a single character.
>
> How can I define multiple characters Terminator Strings ?
>
> ex : id INTEGER EXTERNAL TERMINATED by 'ABC'
>
> It does not work.
>
> Error =
>
> Expecting single char, found "ABC".
> id INTEGER EXTERNAL TERMINATED BY 'ABC',
>
> Regards.

This feature is avalable with Oracle 8i I believe. Are you using Oracle 8i? I don't think the feature's available for 8.0.5.*, 8.0.6.* . Also, could you please post the control file for our benefit?

Regards
Bhooshan Received on Thu Jul 19 2001 - 09:38:05 CEST