apex set debug level
f?p=app:page:session::YES/LEVELx:::
-- x is between 1 (least detailed) and 9 (most detailed)
f?p=100:1:&APP_SESSION.::YES
f?p=100:1:&APP_SESSION.::LEVEL5
-- OR
APEX_DEBUG.enable(p_level)
-- OR
APEX_SESSION.set_debug(p_session_id,p_level) -- p_level: NULL to disableapex_debug example
PROCEDURE my_proc (p_id IN NUMBER, p_emp IN emp%ROWTYPE) IS
BEGIN
APEX_DEBUG.ENTER('my_proc', 'p_id', p_id, 'p_emp.id' , p_emp.id);
APEX_DEBUG.LOG_PAGE_SESSION_STATE; -- saves all items
MY_PACKAGE.MY_FUNCTION;
APEX_DEBUG.LOG_DBMS_OUTPUT(p_prefix=>'[Debug] ');
APEX_DEBUG.INFO('my_proc successfully finished.');
EXCEPTION
WHEN OTHERS THEN APEX_DEBUG.ERROR('Critical error %s', sqlerrm);
RAISE;
END;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
