13 APEX_DEBUG

The APEX_DEBUG package provides utility functions for managing the debug message log. Specifically, this package provides the necessary APIs to instrument and debug PL/SQL code contained within your Application Express application as well as PL/SQL code in database stored procedures and functions. Instrumenting your PL/SQL code makes it much easier to track down bugs and isolate unexpected behavior more quickly.

The package also provides the means to enable and disable debugging at different debug levels and utility procedures to clean up the message log.

You can view the message log either as described in the “ Accessing Debugging Mode” section of the Oracle Application Express App Builder User’s Guide or by querying the APEX_DEBUG_MESSAGES view.

For further information, see the individual API descriptions.

Note:

In Oracle Application Express 4.2, the APEX_DEBUG_MESSAGE package was renamed to APEX_DEBUG. The APEX_DEBUG_MESSAGE package name is still supported to provide backward compatibility. As a best practice, however, use the new APEX_DEBUG package for new applications unless you plan to run them in an earlier version of Oracle Application Express.

• Constants
  
• DISABLE Procedure
  
• DISABLE_DBMS_OUTPUT Procedure
  
• ENABLE Procedure
  
• ENTER Procedure
  
• ENABLE_DBMS_OUTPUT Procedure
  
• ERROR Procedure
  
• INFO Procedure
  
• LOG_DBMS_OUTPUT Procedure
  
• LOG_LONG_MESSAGE Procedure
  
• LOG_MESSAGE Procedure [Deprecated]
  
• LOG_PAGE_SESSION_STATE Procedure
  
• MESSAGE Procedure
  
• REMOVE_DEBUG_BY_AGE Procedure
  
• REMOVE_DEBUG_BY_APP Procedure
  
• REMOVE_DEBUG_BY_VIEW Procedure
  
• REMOVE_SESSION_MESSAGES Procedure
  
• TOCHAR Function
  
• TRACE Procedure
  
• WARN Procedure
  

See Also:

"Accessing Debugging Mode" in Oracle Application Express App Builder User’s Guide