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

Debugging an APEX page


Before you can start by debugging a page, there are some prerequisites. First of all, the debugging property needs to be set to Yes, and second the developer toolbar needs to be visible. Although this last requirement is not strictly necessary, it is very convenient when the development toolbar is visible.

By default, the debugging property is set to No. To switch the debugging property to Yes, follow the steps listed here:

  1. Navigate to the application home page.

  2. Click on Edit Application Properties.

  3. In the Properties section, set the value for Debugging to Yes.

In the preceding screenshot, the Debugging property is set to Yes. This property enables debugging for the entire application.

By default, the developer toolbar is visible when the application is run starting from the development environment in the same browser. The developer toolbar offers a quick way to edit the current page, create a new page, region, or page control, view the session state, or toggle in and out...