Code: Select all
DECLARE
l_value varchar2(100) := 'ERPstuff Error Message';
BEGIN
APEX_DEBUG_MESSAGE.ENABLE_DEBUG_MESSAGES(p_level => 3);
APEX_DEBUG_MESSAGE.LOG_MESSAGE(
p_message => 'This is my message = ' || l_value,
p_level => 1 );
APEX_DEBUG_MESSAGE.DISABLE_DEBUG_MESSAGES();
END;
Level or levels of messages to log. Must be an integer from 1 to 7, where level 1 is the most important message and level 7 (the default) is the least important. Setting to a specific level will log messages both at that level and below that level. For example, setting p_level to 3 will log any message at level 1, 2 or 3.