apex set debug level

Solutions on MaxInterview for apex set debug level by the best coders in the world

showing results for - "apex set debug level"
Enoch
03 Jul 2016
1f?p=app:page:session::YES/LEVELx:::
2-- x is between 1 (least detailed) and 9 (most detailed)
3f?p=100:1:&APP_SESSION.::YES
4f?p=100:1:&APP_SESSION.::LEVEL5
5-- OR
6APEX_DEBUG.enable(p_level)
7-- OR
8APEX_SESSION.set_debug(p_session_id,p_level)    -- p_level: NULL to disable
Anna
17 May 2020
1PROCEDURE my_proc (p_id IN NUMBER, p_emp IN emp%ROWTYPE) IS
2BEGIN
3    APEX_DEBUG.ENTER('my_proc', 'p_id', p_id, 'p_emp.id' , p_emp.id);
4    APEX_DEBUG.LOG_PAGE_SESSION_STATE;	-- saves all items
5    MY_PACKAGE.MY_FUNCTION;				
6    APEX_DEBUG.LOG_DBMS_OUTPUT(p_prefix=>'[Debug] ');
7    APEX_DEBUG.INFO('my_proc successfully finished.');
8EXCEPTION
9    WHEN OTHERS THEN APEX_DEBUG.ERROR('Critical error %s', sqlerrm);
10        RAISE;
11END;