REMOVE_DEBUG_BY_AGE Procedure

This procedure is used to delete from the debug message log all data older than the specified number of days.

Syntax

APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE (
    p_application_id    IN NUMBER,
    p_older_than_days   IN NUMBER);

Parameters

Table: REMOVE_DEBUG_BY_AGE Parameters describes the parameters available in the REMOVE_DEBUG_BY_AGE procedure.

Example

This example demonstrates removing debug messages relating to the current application, that are older than 3 days old.

BEGIN
    APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE (
        p_application_id  => TO_NUMBER(:APP_ID),
        p_older_than_days => 3 );
END;