apex_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;