Re: Generate a text file in stored procedure

From: Avi Abrami <aabrami_at_intersystemsww.com>
Date: Mon, 12 Feb 2001 06:50:13 +0200
Message-ID: <3A876B85.A03A7126@intersystemsww.com>

Chuichi-chan wrote:

> Hi,
>
> Is there any way I can generate a text file in my stored procedure. Say
> I do a query in the stored procedure and want to output the result to a
> text file. Is there any easy to to do this?
>
> Thanks in advance.
>
> Sent via Deja.com
> http://www.deja.com/

Hi Chuichi-chan,
If you are using Oracle 8i, you can use the UTL_FILE package. See the following Oracle documentation:

Oracle 8i Supplied Packages Reference

This is available online from the following URL

http://technet.oracle.com

Good Luck,
Avi. Received on Sun Feb 11 2001 - 22:50:13 CST