Can Oracle7 packages write a flat file ?

From: Roberto Finelli <robertof_at_sofiter.atlink.it>
Date: 1997/04/24
Message-ID: <335F5C76.532D@sofiter.atlink.it>#1/1

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 Received on Thu Apr 24 1997 - 00:00:00 CDT