Oracle Application Server Portal PL/SQL API Reference - 10.1.4

Package wwutl_trace

SQL Execution tracing package (optional installation) This file contains the wwutl_trace package definition. This package, in conjunction with the gateway settings before_proc and after_proc, can be used to run a Portal installation in a mode where it will collection SQL Execution Trace information. It is not installed by default, and must be executed as the Portal schema owner.

Scope:
Public


Function/Procedure Summary
trace_off
Turn off SQL Tracing.
 
trace_on
Turn on SQL Tracing.
 

Function/Procedure Detail

trace_off

procedure trace_off
Turn off SQL Tracing. This routine should be put into the "after_proc" setting in the gateway/listener: after_proc=webdb.trace_off

trace_on

procedure trace_on
Turn on SQL Tracing. This routine should be put into the "before_proc" setting in the gateway/listener: before_proc=webdb.trace_on

Oracle Application Server Portal PL/SQL API Reference - 10.1.4