23.1 SET_DEBUG Procedure

This procedure sets debug level for all future requests in a session.

Syntax

procedure set_debug (
   p_session_id in number default apex.g_instance,
   p_level in apex_debug_api.t_log_level );

Parameters

Table 23-1 SET_DEBUG 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 debug level. 0 or NULL disables debug, 1-9 sets a debug level.

Example 1

This example shows how to set debug for session 1234 to INFO level.

apex_session.set_debug (
    p_session_id => 1234,
         p_level => apex_debug.c_log_level_info );
commit;

Example 2

This example shows how to disable debug in session 1234.

apex_session.set_debug (
    p_session_id => 1234,
         p_level => null );
commit;