Answers for "apex_debug"

SQL
1

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;
Posted by: Guest on July-17-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language