Re: SERVEROUTPUT

On Tue, 17 Apr 2001 12:05:31 -0400, "David Fishburn" <dfishburn_at_home.com> wrote:

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

As usual any search for answers should start in the manual, instead of on Usenet.
So here goes anyway
1 replace all calls to dbms_output by calls to utl_file and do not forget to set the init.ora parameter utl_file_dir to a directory on the server and bounce the database 2 there is no server level option, but of course there is dbms_output.enable(n)
where n is the maximum number of bytes to be outputted, absolute maximum being 1000000
3 Of course Oracle has, but it doesn't contain any messages of the type you are referring to
If you want something likely you can enable tracing in your session and use dbms_application_info to send useful messages to go to the trace file.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Apr 17 2001 - 13:14:24 CDT