Re: SERVEROUTPUT

Hi!

We have also choosen to wrap debug logic into a package on its own, and refers to wrapper procedures instead of DBMS_OUTPUT (or UTL_FILE) directly.
In that way you can add functionality during debug, and remove it in Production.

Frank

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:vh1pdt4b2isrjkkanvlqd18if2rpa6s7t1_at_4ax.com...
> 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:25:22 CDT