Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Open file from PL/SQL
Starting with version 7.3 of the server, you can use UTL_FILE (the server side implementation of the forms TEXT_IO package).
Prior to 7.3 you will need to use dbms_pipes to read a file. You would write a C program to read the file and use dbms_pipes to talk to the C program. To ease this process, you can look at PLEX found on http://govt.us.oracle.com under downloadable utilities.
On 25 Feb 1997 10:18:37 GMT, "ARRASATE SISTEMAS" <arrasis_at_arrakis.es> wrote:
>
> Hi Oraclers:
>
> I need to open an ASCI file from a stored procedure and I donĀ“t know how.
>I know how I can make in Forms, through the Package TEXT_IO and its
>functions FOPEN, PUT_LINE ...
>
> The file would content something like the following:
>
> Hello Oracle-world<EOL>
> Bye<EOL>
> <EOF>
>
> Can anybody help me ?
>
> Thanks in advance.
>
> Clemen.
>
>____________________________________________________________________________
>
>
> Arrasate Sistemas S.L.
> Mondragon (Gipuzkoa)
> Spain
>
> arrasis_at_arrakis.es
>____________________________________________________________________________
>
>
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com