O'Reilly logo

Oracle APEX Best Practices by Learco Brizzi, Iloon Ellen-Wolff, Alex Nuijten

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Debugging and Troubleshooting

Debugging Oracle Application Express can be a conundrum. Oracle APEX is a blend of technologies – PL/SQL and SQL that generates HTML pages using CSS, templates, and JavaScript. Tracking and resolving problems in this multi-layer environment necessitates a blend of tactics to examine what is happening in each component of the application.

This chapter will cover the following topics:

  • Debugging in APEX
  • Remote debugging using Oracle SQL Developer
  • Web development tools
  • Reports available in Application Express for troubleshooting
  • Advisor

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required