Overview | Package | Object Type | Deprecated | Index | Help
| Oracle Application Server Portal PL/SQL API Reference - 10.1.4
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES
SUMMARY: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE | DETAIL: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE

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

Overview | Package | Object Type | Deprecated | Index | Help
| Oracle Application Server Portal PL/SQL API Reference - 10.1.4
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES
SUMMARY: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE | DETAIL: EXCEPTION | TYPE | CONSTANT | VARIABLE | FUNCTION/PROCEDURE