Re: Oracle 7.3.4 : how to write in file, lines larger than 1000 char

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 Oct 2003 05:52:49 -0800
Message-ID: <2687bb95.0310290552.35f7e46c@posting.google.com>

"Jérôme VUIBERT" <jerome.vuibert_at_fleximage.fr> wrote in message news:<3f9f92c7$0$11226$636a55ce_at_news.free.fr>...
> Hi.
>
> I really hope than someone could help me to resolve this problem.
>
> I have an old, very old, Oracle 7.3.4 database. I have to get some datas
> from this database and write then in a file.
>
> Unfortunnelly for me, some lines are larger than 1000 characters.
>
> Does someone know how to write in a file some kind of lines ?
>
> Thanks a lot for your help.
>
> Jerome

Jerome, you did not say what tool you are using but I would guess from the fact that 1,000 characters seem to be a problem that you are trying to use utl_file. Either break the output into shorter lines and put them back togeter at the OS level or use a better tool for the job such as Pro*C.

HTH -- Mark D Powell -- Received on Wed Oct 29 2003 - 07:52:49 CST