SET_DEBUG Procedure

51.5 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

Parameters Description

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. NULL disables debug, 1-9 sets a debug level.

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. 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;