Try using the utl_file stored procedure. It works great.
You must have utl_file_dir set in your init.ora.
Stephen C. Ashmore
Brainbench MVP for Oracle Administration
"David Fishburn" <dfishburn_at_home.com> wrote in message
news:9bhpis$eht$1_at_newswest.sybase.com...
> 8.1.7
> I am trying to debug an application and I need some help.
> The database procedures and packages make extensive use the of DBMS_OUTPUT
> statement.
> The connection to the database is made from an EJB running in an
application
> server.
> Therefore I cannot use the SET SERVEROUTPUT ON, since I am not making the
> connection myself.
>
> In other databases like Sybase ASE or Microsoft SQL Server I can use the
> print statement.
>
> What I would really like to do is this:
> 1. Redirect all the DBMS_OUTPUT statements to a LOG on the server.
> 2. Set some server level option (for all connections) to turn on the
SERVER
> OUTPUT so that I can get these messages.
> 3. I am not sure if Oracle has a database log (fully of messages), that I
> can go to view the outputted messages.
>
> Can anyone suggest anything?
>
> Thanks,
> Dave
>
>
Received on Tue Apr 17 2001 - 11:22:17 CDT
