Re: PL/SQL: Reading/Writing to a file

From: terryg8 <trg_at_ibm.net>
Date: 1997/09/05
Message-ID: <3410BA80.47ED@ibm.net>#1/1

Fenella Tan wrote:
>
> Can anyone tell me if there is any other way of reading/writing external
>
> text files from PL/SQL ?
> Currently, I'm using the UTL_FILE package, but I recently found out that
>
> it is capable of reading (using the GET_LINE procedure) only 1022 bytes,
>
> and writing (using PUT_LINE) only 1023 bytes. The data I'm working with
>
> will probably be around 7K per line.
>
> Any input is appreciated.
>
> Thanks
> Fenella Tan

It's simplest methinks to preprocess the file in your operating system environment. Sometimes that's the only way.
What is your OS? Betcha someone in this group has what you need.
TRG Received on Fri Sep 05 1997 - 00:00:00 CDT