30.2 SET_TRACE Procedure

This procedure sets trace mode in all future requests of a session.

Syntax

procedure set_trace (
   p_session_id in number default apex.g_instance,
   p_mode in varchar2 );

Parameters

Table 30-5 SET_TRACE Procedure Parameters

Parameters Description

p_session_id

The session id.

Note : The session must belong to the current workspace or the caller must be able to set the session's workspace.

p_level

The trace mode. NULL disables trace, SQL enables SQL trace.

Example 1

This example shows how to enable trace in requests for session 1234.

apex_session.set_trace (
    p_session_id => 1234,
          p_mode => 'SQL' );
commit;

Example 2

This example shows how to disable trace in requests for session 1234.

apex_session.set_trace (
    p_session_id => 1234,
          p_mode => null );
commit;

Parent topic: APEX_SESSION