Debugging and Troubleshooting - Oracle APEX Best Practices - page 197

Procedure Usage

LOG_PAGE_SESSION_STATE Emit session state information into the DEBUG table

REMOVE_DEBUG_BY_AGE

Remove debug messages for a given application older
than N days

REMOVE_DEBUG_BY_APP Remove debug messages for a given application

REMOVE_DEBUG_BY_VIEW Remove debug messages for a given application and

page view ID

REMOVE_SESSION_MESSAGES Remove debug messages for a given session

The following is an example of enabling debug messages for a speciic user in the
page rendering process—Onload/Before header header.

IF :APP_USER = 'XX' THEN
apex_debug_message.enable_debug_messages;
END IF;

The REMOVE_DEBUG_BY_AGE procedure takes two arguments:

(p_application_id in number default null,
P_older_than_days in number default null);

This example shows how the REMOVE_DEBUG_BY_AGE procedure is used.

Before we can use the procedure to remove the debug information, we irst need to
create some debug information. Debug information is created when the View Debug
button in the developer toolbar is pressed.

The following steps will guide you through this process:

1. Edit the page, and in the Processes section, click on the Create icon, to add a

new process to this page. This will launch the C reate Page Process wizard.

2. Select category PL/SQL, and click on the Next button.

3. Type Clear Debug Info , ensure that Point is set to On Load -Before

Header , and click on Next .

4. Under the Source heading, enter the following code:

apex_debug_message.remove_debug_by_age
(p_application_id => :APP_ID
,p_older_than_days => 1
);