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

Remote debugging


The easiest way to illustrate remote debugging is to use Oracle SQL Developer with an application in APEX. The subprogram resides in APEX, and Oracle SQL Developer is used to debug it. This capability is especially useful when an application isn't failing but also isn't producing the results you expect. The following grants are necessary before performing remote debugging:

grant DEBUG CONNECT SESSION to <schema>; 
grant DEBUG on <object> to PUBLIC;
grant DEBUG ANY PROCEDURE to APEX_PUBLIC_USER;

Or ANONYMOUS when using the embedded gateway.

  1. Connect Oracle SQL Developer and import the APEX application.

  2. Set a breakpoint in the code that needs to be debugged.

  3. Compile the procedure for debug.

    Note that running a package in debug mode severely hampers performance. Once testing is complete, compile the package without debug information.

  4. At this point, prepare Oracle SQL Developer for remote debugging. Do this by selecting the connection that will be used for debugging the...