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 downloads of Oracle SQL Developer can be found at:
http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
To demonstrate debugging with Oracle SQL Developer, create the following procedure:
Note
The procedure is for demonstrations...
