Re: Producing output files

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 18 Jun 2001 08:02:34 -0700
Message-ID: <9gl56a014nn@drn.newsguy.com>

In article <5c5c8561.0106180419.4789e17d_at_posting.google.com>, benetnasch_at_blimey.co.uk says...
>
>Hello,
>
>I have been assigned a task which involves the creation
>of an output file (ASCII) in a specified format. I'm
>using PL/SQL to do all the other associated processing,
>but am not sure whether I can use PL/SQL to produce
>the output file. Can I? The only output feature I'm
>aware of is DBMS_OUTPUT...
>
>Thanks for any help.
>
>Benetnasch

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:235814350980 for a pure plsql method using UTL_FILE and http://osi.oracle.com/~tkyte/flat/index.html for a sqlplus way to do it.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Jun 18 2001 - 10:02:34 CDT