Re: Open file from PL/SQL

Connor McDonald wrote:
>
> 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

The package is UTL_FILE. Use the UTLFILE.SQL procedure to create it.

-- 
================================
         James H. Yoshii  
 IntelliTech Business Solutions
        yoshii_at_planet.net
================================