Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Open file from PL/SQL
ARRASATE SISTEMAS 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
> ____________________________________________________________________________
Under Oracle 7.3 (ie PL/SQL 2.3) there are built-in procs to do pretty much the same as TEXT_IO does in forms. Can't remember the name - DBMS_FILE. ??? or something similar
-- Connor McDonald Systems Administrator-Unix/Oracle BHP Iron Ore "You're not drunk if you can lie on the floor without holding on" - Dean MartinReceived on Wed Feb 26 1997 - 00:00:00 CST