Databases Reference
In-Depth Information
The following image shows the remote debug connection:
This prepares Oracle SQL Developer for the connection to the debugger and opens
the process. Application Express also needs to be prepared for remote debugging.
This is done by performing the program in debug mode, and changing
YES
in the
URL to
REMOTE
(the ifth position in the URL).
Steps to be performed in APEX
The necessary steps in APEX to perform remote debugging are as follows:
1.
Execute the program in Application Express.
2.
Click on
Debug
in the developer toolbar when you want to debug.
3.
Change the
YES
in the URL to
REMOTE
.
The following is an example of the URL for performing remote debugging out of an
APEX application:
http://host:port/apex/f?p=103:11:6993768986060180::REMOTE
Now, debugging can be performed in Oracle SQL Developer. The APEX application
will wait for the debugging process to complete. At this point, it is not possible
to continue working with the application. On the other hand, this is not the
purpose - keep the application online at this time. When debug is ready, control
is given back to the APEX application.
