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

APEX and Oracle SQL Developer

APEX and Oracle SQL Developer can work perfectly together. For troubleshooting PL/SQL code within APEX, remote debugging can be very handy.

Oracle SQL Developer is a graphical user interface that allows you to browse database objects, run SQL statements and scripts, and debug PL/SQL statements. Before concentrating on the integration of Oracle SQL Developer and APEX, we are going to look at how debugging is done in Oracle SQL Developer. Oracle provides two packages for debugging PL/SQL code. The first, DBMS_DEBUG, was introduced in Oracle version 8i and not used anymore in Oracle SQL Developer. The second, DBMS_DEBUG_JDWP, was introduced in Oracle version 9i and is used by Oracle SQL Developer.

More information and ...

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