51.7 SET_TRACE Procedure
This procedure sets trace mode in all future requests of a session.
Syntax
APEX_SESSION.SET_TRACE (
p_session_id IN NUMBER DEFAULT apex_application.g_instance,
p_mode IN VARCHAR2 );Parameters
| Parameters | Description |
|---|---|
p_session_id |
The session ID. 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