Re: Can Oracle7 packages write a flat file ?

Steve Phelan wrote:

> 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.

 Also, look in the on-line books to see about this because you must specify what directories you can access from Oracle in your .ORA file before you open a file in that directory. On NT4.0, I could not specify an individual directory, so I had to put * as the directory...

   Fred Received on Tue Apr 29 1997 - 00:00:00 CDT