Re: How to Output Multiple Files from PL/SQL

A copy of this was sent to Roger Stapley <rstapley_at_uk.oracle.com> (if that email address didn't require changing) On Tue, 25 Jan 2000 15:44:33 +0000, you wrote:

>Hi,
>
>Anyone give me some pointers on how to output multiple files from
>PL/SQL, I want to loop through a couple of tables and output different
>values to three different files.
>
>(is there a dbms_output.put_line(filename, 'Value') for example)
>

see the UTL_FILE package. It works with >1 file.

>If the answer is RTFM, then please let me know which manual!
>

plsql manual (8.0 and before) or supplied packages guide (8i and up)

>Any ideas appreciated.
>
>Thanks.
>
>Roger.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jan 25 2000 - 10:02:21 CST