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

From: Kevin O'Connor <kkoconn_at_magma.ca>
Date: 1997/09/17
Message-ID: <341f1d4e.742018@news2.magma.ca>#1/1

On Sat, 06 Sep 1997 20:52:21 -0400, Fenella Tan <fenella_at_voicenet.com> 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
>

Spool myfile.lst

Begin pl/sqlblock

..
..
..

end

spool off

You'll want to use the dbms_output package of course to send text to the terminal , and set server output on , of course...

Or give it up , create a temporary table to hold results, and then just to a spool , select * from temp, spool off. Received on Wed Sep 17 1997 - 00:00:00 CDT