oracle apex debug message
DECLARE
l_value varchar2(100) := 'test value';
l_long_msg VARCHAR2(32767) := 'output anything up to varchar2 limit';
BEGIN
APEX_DEBUG_MESSAGE.ENABLE_DEBUG_MESSAGES(p_level => 3); -- 1 is most important
APEX_DEBUG_MESSAGE.LOG_MESSAGE( -- Short message (4000 max)
p_message => 'l_value = ' || l_value, p_level => 1 );
APEX_DEBUG_MESSAGE.LOG_LONG_MESSAGE(
p_message => l_long_msg, p_level => 1 ); -- Long message
APEX_DEBUG.INFO('Information message');
END;