Re: Open ASCII file from PL/SQL

From: Ronald <ronr_at_worldaccess.nl>
Date: 1997/02/27
Message-ID: <ronr-2702972014030001@news.worldaccess.nl>#1/1

In article <331211A0.34D8_at_arrakis.es>, "Arrasate Sistemas S.L." <arrasis_at_arrakis.es> wrote:

> Hello:
>
> Does anybody know how can I open an asci file from PL/SQL ?
>
> I need to open an asci file from PL/SQL similar as I can do with
> TEXT_IO.OPEN_FILE.
>
> I want to do something like this:
>
> fichero:=FOPEN('C:\MY_FILE.TXT','W');
> TEXT_IO.PUTLINE(fichero,'HELLO WORLD');
> FCLOSE(fichero);
>
> The file would content:
>
> HELLO WORLD<EOL>
> <EOF>

Hi Clemen,

You can use DBMS_PIPES to pass the info to an applicationserver that takes care for the filehandling.

Cheers,

Ronald.

---

http://www.worldaccess.nl/~ronr (last update februari 17, 1997) Received on Thu Feb 27 1997 - 00:00:00 CST