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