oracle apex view logs
SELECT * FROM APEX_WORKSPACE_ACTIVITY_LOG WHERE WORKSPACE = 'wks_name' AND APEX_USER = 'user_name' AND APPLICATION_ID = 'app_id'; SELECT * FROM APEX_DEBUG_MESSAGES;
Source: blogs.infomentum.com
oracle apex view logs
SELECT adb.APEX_USER, adb.APPLICATION_ID, wal.APPLICATION_NAME, adb.PAGE_ID, adb.MESSAGE, adb.MESSAGE_TIMESTAMP, adb.PAGE_VIEW_ID, adb.SESSION_ID FROM APEX_WORKSPACE_ACTIVITY_LOG wal INNER JOIN APEX_DEBUG_MESSAGES adb ON wal.DEBUG_PAGE_VIEW_ID = adb.PAGE_VIEW_ID;
Source: blogs.infomentum.com