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 Martin