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;
