oracle apex charging debug

DECLARE
    l_value varchar2(100) := 'test value';
    l_long_msg VARCHAR2(32767) := 'output anything up to varchar2 limit';
BEGIN
    APEX_DEBUG_MESSAGE.ENABLE_DEBUG_MESSAGES(p_level => 3);  -- 1 is most important
    APEX_DEBUG_MESSAGE.LOG_MESSAGE(					-- Short message (4000 max)
        p_message => 'l_value = ' || l_value, p_level => 1 ); 
    APEX_DEBUG_MESSAGE.LOG_LONG_MESSAGE(
        p_message => l_long_msg, p_level => 1 );   	-- Long message   
    APEX_DEBUG.INFO('Information message');
END;

View another examples Add Own solution

Mohamed Lamine Hasan 95 points

                                    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;

Thank you! 5

Elliot svensson 100 points

                                    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=&gt;'[Debug] ');
    APEX_DEBUG.INFO('my_proc successfully finished.');
EXCEPTION
    WHEN OTHERS THEN APEX_DEBUG.ERROR('Critical error %s', sqlerrm);
        RAISE;
END;

Thank you! 10

4.1

Jaylen Medina 105 points

                                    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;

Thank you! 10

4.1 (10 Votes)

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

oracle apex charging debug

Welcome Back!

Create a Free Account