Re: logging information from a stored procedure calls

booksnore wrote:
> Hi,
> I'm involved in performance analysis for an application that calls a
> stored procedure that contains if logic. I need to log how many times
> logic conditions within the procedure are met so I need to write
> information to a log. So it would be something like this...
>
> CREATE OR REPLACE PROCEDURE test1 (
> myValue in char)
> is
> begin
>
> if myValue is null then
> -- write information to log saying stored procedure test1
> -- condition 1
> else
> -- write information to log saying stored procedure test1
> -- condition 2
>
> end if;
>
> END test1;
> /
>
> What's the easiest way to implement this in PL/SQL? I have no access
to
> any monitoring tools. The procedure is called from a web application,
> my only means of logging would be to a file. Any help appreciated.

Basically you want to debug the procedure. Goto http://tahiti.oracle.com and look up usage for dbms_output and/or utl_file packages.

Regards
/Rauf Received on Thu May 12 2005 - 09:07:09 CDT