Re: Can Oracle7 packages write a flat file ?

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/04/24
Message-ID: <335F6A50.D9619097@pmcgettigan.demon.co.uk>#1/1

Roberto Finelli wrote:

> I need to log the errors that happen during the execution of a
> PL/SQL
> package in Oracle7.
> I wish to log in a flat file, but DBMS_output seems not to be able
> to
> open files.
> In addition, the package is run by a Visual Basic client via
> SQL*Net, so
> I can't run the package in SQL*Plus and use the SQL*Plus log file.
> I still don't know where DBMS_Output goes in this conditions.
> I've read the use of pipes towards other processes to do so, but
> this
> may add complications because I must deal with transactions.
>
> Can someone help me?
> Thanks

If you are using Oracle 7.3, try looking at the UTL_FILE package.

Steve Phelan. Received on Thu Apr 24 1997 - 00:00:00 CDT