Book Image

Oracle APEX Best Practices

Book Image

Oracle APEX Best Practices

Overview of this book

Have you ever wanted to create real-world database applications? In this book you're not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it."Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, security, and getting the best out of SQL and PL/SQL.In six distinct chapters you will learn about different features of Oracle APEX as well as SQL and PL/SQL.Do you maximize the capabilities of Oracle APEX? Do you use all the power that SQL and PL/SQL have to offer? Do you want to learn how to build a secure, fully functional application? Then this is the book you'll need. "Oracle APEX: Best Practices" is where practical development begins!
Table of Contents (14 chapters)
Oracle APEX Best Practices
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

APEX_APPLICATION.G_DEBUG


The APEX_APPLICATION package enables users to take advantage of global variables. The apex_application.g_debug variable refers to whether debugging is currently switched on or off. Valid values for this variable are TRUE or FALSE.

Turning debug ON shows details about application processing.

For example:

IF apex_application.g_debug THEN 
  apex_debug_message.log_message('Custom Validation'); 
END IF;

Including the preceding code in the APEX page, anywhere where PL/SQL is allowed, will add information visible in APEX_DEBUG_MESSAGES, and therefore in the View Debug page. This information will only be added when apex_application.g_debug evaluates to TRUE.

The debug Advanced Programming Interface (API)

The APEX_DEBUG_MESSAGE 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 the APEX application as well as the PL/SQL code in database stored procedures...